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

# Count three values in a column

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 !

• ###### 1. Re: Count three values in a column

clarification !  the sample expression was names "Test A Totals".  it should only return 2000.  I have one for Test B and Test C and it's shortened accordingly

Test B Totals

COUNT([Test Procedure]='Test B')+COUNT([Test Procedure]='Test C') >>> returns 4000

Test C Totals

COUNT([Test Procedure]='Test C') >> returns 2000

• ###### 2. Re: Count three values in a column

Are the Tests all part of the same dimension? Are you able to post a sample workbook (twbx file) ?