Sum of a group total

[maas]

Hello,

I am having difficulties while getting the total of each group.My report is having multiple formulas.
I am listing a number of currencies and beside them is their amount.
I am placing the Totals in a formula near each group name.
My report looks like:
G-F3: Currency and a formula called "Exec"
"{@Exec}" formula = e.amount - b.share
G-F2: where I am trying to get the total of "{@Exec}"

My condition is that I want to list all the currencies and the total of them, except the "USD". The amount of the "USD" i want it separately.
Also, I want to have the total of all the currencies "non-US" + "US" at the end of the report.

 

[lbass]

Please show the content of your exact formulas, not descriptions, and identify the names of the fields you are working with. Also, identify the fields you are grouping on. It looks from the above that you are placing a detail level formula in a group footer--which would only reflect the values in the last record of the group, and would not act as a summary.

-LB

 

[Madawc]

Do a couple of running totals for the whole report, one for USD and one for everything else. A running total lets you use a formula to add or not add.

The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP