Newbe Formula Qustion 1

[sclark415]

Sorry the question is so basic. I am using v9.2 - I have to sum up recordtype A and recordtype B separtely (only have 2 types). Then sum both recordtype A and recordtype B together for the report totals. How do I do this? My report is in a group footer since all I need is the totals.
Thanks!

 

[lbass]

If they are from the same field {table.type} then create two formulas:

//{@typeA}:
if {table.type} = "A" then {table.amt}

//{@typeB}:
if {table.type} = "B" then {table.amt}

Then right click on each formula and insert a summary (sum).

If you want to count these records, substitute a 1 for {table.amt} and then again, insert a sum.

-LB

 

[sclark415]

Thank you for your help! I appreciate it!