add and subtract summary group totals

[Former Member]

Looking for a way to add and subtract summary group totals in a report.

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with your directly

[Former Member]

If you always want the sum of 51 + 61 then subtract 70

create three running totals. 51, 61, 70

( For the running total Field to summarize would be your amount )

Evaluate on a formula

account = 51

(This running total will sum the amounts, each time the account = 51)

reset on change of group, or never, depending on what you want.

You can create a formula

({#51}+{#61})-{#70}

This should work just fine.

[Former Member]

create a formula like this

sum({sales.amt}, ) + sum({sales.qty}, )

Regards,

Zack H.

Edited by: Zack H on Aug 20, 2009 5:00 PM

[Former Member]

I have my data grouped by account type then summarized. Example

have my data grouped by account type then summarized. Example

acct. type amount

51 $100

51 50

Summary $150

61 $100

61 100

Summary $200

70 $50

70 50

Summary $100

Formula I want to make this formula 51+61-70 = GP

I am trying to understand how to put the acct. type(51,61) in the formula and insert in the report.

Thanks for the help.

Raald232