Skip to Content
author's profile photo Former Member
Former Member

Help with report please

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}


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.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Feb 22, 2017 at 09:12 AM

    I would create 3 formulae


    If {Product.Grade1} ="A" then 1 else 0

    Repeat for Grades 2 & 3

    In report footer add formula


    sum(@PG1A) + sum(@PG2A) + sum(@PG3A)


    Add comment
    10|10000 characters needed characters exceeded