I have a report with 3 columns.The field names are column1 = {Product.Grade1}, column2 = {Product.Grade2} and column3={Product.Grade3}.
Each column can have any value from A to C . For each column, I am trying to total records that have only the instances that ‘A’ is shown in the column.
First, I wrote a formula to display only the A in the column1
The formula I used for column 1:IF {Product.Grade1} ="A"
THEN {Product.Grade1}
ELSE ""
This displays only the A in the first column.However, when I try to get a total of only the A’s it will give me a total of everything that is in the column, visible or hidden. I tried sum and running total but both didn't work.
How do I get it to display only the count for the A’s in each column?
Thank you for your help.
I would create 3 formulae
@PG1A
If {Product.Grade1} ="A" then 1 else 0
Repeat for Grades 2 & 3
In report footer add formula
@TotalA
sum(@PG1A) + sum(@PG2A) + sum(@PG3A)
Ian