Count Formula

[lisa626]

I am using Crystal XI and have the following...

Group 1 BAAAME NON REFUNDABLE
Detail 132456 640.20 1 0

BAAADG NON REFUNDABLE
123654 246.04 1 0

BAABFP REFUNDABLE
458975 326.60 0 1

CDEFJJ REFUNDABLE
987589 1.00 0 1

UEIRRU NON REFUNDABLE
458796 711.54 1 0
987541 336.27 1 0

I need to show that there are 3 NR tickets with a total price of 1934.05 and 2 R tickets with a total price of 327.60. I can get the formula for the prices down, that is working. What I am having trouble with is I can't get it to show 3 NR, it keeps showing 4, technically there are 4 but I want it to show 3 cause i need it to sum at the group level and count the two tickets under UEIRRU as 1.

Is this possible???

 

[Madawc]

Do a running total with a Distinct Count based on the field with the 'UEIRRU'. Made it conditional on there being a 'refundable' for the group.

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