Summary total does not return expected results 1

[GuyHamasaki]

I am grouping a report and have fields on the Group Header section. In one section of the report I have Budget, Actual and Over/Short columns. The data below appears in the Group Header section

Rep Budget Actual Over/Short
--- ------ ------ ----------
CC 10 11 1
RW 4 5 1
EF 12 9 -3

In the report footer, I have the totals for each column. The budget and actual report totals behave correctly. To get those total, I use the following formula:

if a = b then
1
else
0

I insert a summary for the formula field to come up with acutal and budget totals for each rep.

To get the Over/Short column, I thought using a formula of Sum(Actual) - Sum(Budget) would work for each line item. However, it did not behave this way. It gave me the same result for each line item, which is equal to the Total Over/Short. Why does it not give me the individual Over/Short for each rep?

Thanks in advance.

Guy

 

[dgillz]

Sum(Actual) - Sum(Budget) would give you the difference between two grand totals, in your case the difference between 26 and 25, or 1. This is behaving as expected.

Your formula should look like this:
Sum({Actual},{Rep})-Sum({Budget},{Rep})

I am using {rep} in this formula as this is what you have as a header for column 1. Notice the difference between the grand total sum() in your formula, and a subtotal sum() in mine, which has another argument, namely the field being subtotaled, or {rep}.

Please post again if you still have problems. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[GuyHamasaki]

dgillz...this is precisely what i need! thanks for the help as this will continue to help me in similar situations. thanks again. guy