Skip to Content
0

Help with report please

Feb 21, 2017 at 08:10 PM

36

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ian Waterman Feb 22, 2017 at 09:12 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded