Summary formula

[neeko1226]

I'm trying to sum two number fields where another text field is within a given set of values. the report is grouped by transaction date.
Here's an example:

F1-F4 are field pulled in from a query in Access.


GroupHeader(suppressed)
F1 F2 F3 F4

TranDate CountofA CountofB ValueA

7/1/03 36 25 ddd

Detail 7/1/03 21 30 xxx

7/1/03 15 10 ttt


GroupFooter 72 65
(subtotal of (subtotal of
CountofA) CountofB)

I need to add a formula to show: Sum(CountofA) where {ValueA} is one of "ddd" or "ttt".

Getting grey hairs by the second!

Neeko

 

[lbass]

Try adding a formula {@valueAdddttt} to your detail section:

if {table.valueA} in ["ddd","ttt"] then {table.CountofA}

Insert a sum on this at the group level.

-LB

 

[neeko1226]

Thanks much! That works wonderfully.

Neeko