Counting True/False

[Rob2k2]

I have a field PPP, which is either true or false but what I want to do is count the number of Trues and divide them by the total number of entries. Is there an easy way to do this?

 

[Naith]

In the section containing {PPP};

WhilePrintingRecords;
NumberVar TrueCount;

If {PPP} = 'True'
Then TrueCount := TrueCount + 1
Else TrueCount;

At the end of your report;

WhilePrintingRecords;
NumberVar TrueCount;

Count({PPP}) / TrueCount

Naith

 

[Rob2k2]

Thanks a lot, this works well however is it possible to do it per group as opposed to a total number for all the data?

 

[Naith]

In your Group Header;

WhilePrintingRecords;
NumberVar TrueCount := 0;

In your Group Footer;

WhilePrintingRecords;
NumberVar TrueCount;

Count({PPP},{GroupField}) / TrueCount

Naith

 

[Rob2k2]

How do you insert formulas into the group header?

 

[Naith]

I'm not sure I understand what you mean. Click and hold on your field and drag it into the Group Header section.

 

[Rob2k2]

Thanks, it all works!