counting

[Paul1981]

Hi,

i have a field in my group which contains values. Is there a way of counting the amout of "200"'s?

For example:

100
200
200
50
200

the count would be- 3

Thanks

Paul

 

[IanWaterman]

Couple of ways

create formula
@Count

If Field = 200 then 1 else 0

Then do a summary in report footer which sums this formula

If the 200 exists a group sum then you will need to use a variable. Place this formula in group footer where 200 is displayed.

@count
whileprintingrecords;

global numbervar 200count;

If Sum(field, groupfield) = 200 then
200count = 200count+1;

In report footer display variable
@displaycount

whileprintingrecords;

global numbervar 200count;

Ian

 

[Paul1981]

Thanks for that Ian!

works a treat!