Math - Specific Amt in Detail to create Amt in Footer

[giggles7840]

Ok, this seems tricky to me..... I will try and explain it the best i can...

I have a report and in the detail section I have an Act Name and an Amt. So it looks like:

D- Revenue - blah blah 100.00
D- Revenue - blah 2 400.00

D- Gross Rev 500.00
D- Sub 50.00
D- ODC 25.00

GF- Net Rev

I need to find a way to create a fomula which will allow me to subtract the Sub line and the ODC line from the Gross Rev line to create a Net Rev amt on the Group footer line. I am having trouble separating those numbers from the rest of the detail amt's.

Any ideas?
Thanks for you help.

 

[Madawc]

Try running totals to pick up just those values.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5

Madawc Williams (East Anglia, UK)

 

[giggles7840]

im running 9.0

 

[giggles7840]

how would i do a subtraction in a running total? i need to subtract the Sub and ODC detail line from the Gross Rev Detail Line.

 

[Madawc]

What I'm suggesting is that you use the formula in a running total to get the values of the Sub and ODC detail line, both together or as two separate totals, depending on how you recognise them. Then do a formula in which you subtract these values from the gross value.

Madawc Williams (East Anglia, UK)

 

[lbass]

You could create a formula like the following {@amt}:

if {table.acctname} in ["Sub","ODC"] then -{table.amount} else {table.amount}

Then right click on this formula and insert a sum to get the group total (Net Revenue). If you need to show a separate total for revenue, then create a formula like:

if {@amt} > 0 then {table.amount}

Then insert a summary (sum) on this to get total revenue.

-LB