2 Replies Latest reply on Nov 30, 2012 11:44 AM by Tracy Rodgers

    Count three values in a column

    Son Nguyen

      Hi, I can't figure this out, should be easy but maybe not.

       

      I have a column with 2000 rows.  The 2000 rows have three different names but each are "nested" inside another...example

       

      Test Procedure (column)

      Row 1 > Test A

      Row 2 > Test B

      Row 3 > Test C

      Row 4 > Test B

      Row 5 > Test A

      Row 2000 > Test x...

       

      Test A has A, B and C totals

      Test B has B and C totals

      Test C is C totals

       

      How to I create a calculated field to get totals for A, B and C ?

       

      Tried the following and it's giving me a total of 6000 because it's adding all the rows (A=2000 + B = 2000 + C=2000)

       

      COUNT([Test Procedure]='Test A')+COUNT([Test Procedure]='Test B')+COUNT([Test Procedure]='Test C')

       

      Did not an error when saving the calculated field.

       

      Tx !