473,372 Members | 1,099 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Help needed with formula in report. Was Help with code needed!

4
I am trying to figure out some code for a report issue;

I have an employee who has a incentive scheme.

I have a report showing various income amounts and in the report footer I vae totals for these feilds =sum([XXX]) these work fine.
I also have in the detail feild Overall text boxes for the three feilds concerned
I then have in the report footer =[xx]+[xx]+[xx] which give me a grand total for the report also works fine.

I now need to have a more complex formula which alows for;

if the grand total is greater than 8333 then subtract from the grand total 8333 then divide the new total by 2
I have this formula in excel and it is written =if(total>8333,total-8333)/2

Any help with this will be greatly appreciated!

Bob
Aug 8 '07 #1
7 1741
missinglinq
3,532 Expert 2GB
Please remember to provide a meaningful Title for any threads you start! This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

http://www.thescripts.com/forum/thread559246.html


Thank you and Welcome to TheScripts!!

Linq ;0)>
Aug 9 '07 #2
missinglinq
3,532 Expert 2GB
If the grand total is not greater than 8333, what are you going to do with control?

Something like this:

= IIf(Me.total > 8333, (total - 8333) / 2, "N/A")

will do the math if the total is over 8333, and place "N/A" in the control if if the total is not over 8333.

Linq ;0)>
Aug 9 '07 #3
Bobh
4
If the grand total is not greater than 8333, what are you going to do with control?

Linq ;0)>
will leave at 0 or leave blank
Aug 9 '07 #4
missinglinq
3,532 Expert 2GB
O.K. this should do:

= IIf(Me.total > 8333, (total - 8333) / 2, 0)

Linq ;0)>
Aug 9 '07 #5
Bobh
4
If the grand total is not greater than 8333, what are you going to do with control?

Something like this:

= IIf(Me.total > 8333, (total - 8333) / 2, "N/A")

will do the math if the total is over 8333, and place "N/A" in the control if if the total is not over 8333.

Linq ;0)>
Tried this thanks but I am being asked to enter a Parameter value for Me.total?
Aug 9 '07 #6
missinglinq
3,532 Expert 2GB
I'm sorry, that was the name I used in checking the code. Replace Me.Total with your total, if that's the actual name you're using.

= IIf(total > 8333, (total - 8333) / 2, 0)

Linq
;0)>
Aug 9 '07 #7
Bobh
4
I'm sorry, that was the name I used in checking the code. Replace Me.Total with your total, if that's the actual name you're using.

= IIf(total > 8333, (total - 8333) / 2, 0)

Linq
;0)>
Ah-Ha!

Could you help me with something else please?

On my form I have a:

Purchase Amount Purchase Commision Commission Amount
Refinance Amount Refinance Commission
Top Up Amount Top Up Commission

Where I enter the amount, I then tick the appropriate commision amount and the Purchase, Refinance or Top Up Commission amount are calculated to those areas automatically.

I now have the problem that when I go to Reports, i insert a text box in the detail area and associate with the form Purchase, Refianance or top up for a control source but when I preview the report that area is blank on the report.
Do I have a setting problem is is it not possible to report on calculated totals?

Regards,

Bob
Aug 9 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

41
by: Seth | last post by:
I am in need of source code for the Aho Corasick algorithm. I have tried searching the web but can't seem to find any code. Is there a good site for c code I can search? Thanks in advance.
2
by: Efy. | last post by:
Hello all! I wonder if the following subject is a Crystal issue or what? When ever I have a field that includes hebrew(-RTL language) and numbers all the spaces beetwen the words and the numbers...
1
by: Brian | last post by:
When useing a Crystal Report (CR) bound to a dataset.xsd, the paramenter do not show up in the CR Field Exploere. Yes I can access them via my VB.Net code, but I am unable to access them and their...
0
by: RJN | last post by:
Hi I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the formula in the main...
0
by: RJN | last post by:
Hi Sorry for posting this message again. I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be...
0
by: rjn | last post by:
Hi I have a main report in which I have inserted a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the...
0
by: =?Utf-8?B?TGV0emRvXzF0?= | last post by:
I'd like to create a Macro that will sort some raw data, apprx 20k lines, remove some lines based upon a condition in a certain column. Then copy this data into a new spreadsheet and sort the ...
0
by: gkinu | last post by:
Crystal Report for Visual Studio.NET 2003. I have a formula that brings an error " .. A number is required here ... ". See the code snippet below which i have simplified. In the actual formula,...
3
by: muddasirmunir | last post by:
i am using vb6 and crystal report 10 with sqlserver 2000 i made a formulal field in crystal report 10 where i had a table name sales , it has two numeric fields credit and debit and give theme...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.