Count

[zoster]

Hello all,

My question is related to counting number of records in the results section. In the list below I would like the count to return 2 not the the total number of records 4. Therefore I tried the solution proposed in this older thread(see link below) but there is something wrong with my formula since it returns #NAME!.

a) Does anyone know how to fix this error in Step 2 (computed 2 column)?
b) After I get a value of 1 or 0 in Step1 how do I sum up so I get the count per each line?
c) Is there any easier solution?

supervisor staff member computed 1 computed 2 count(desired result)
1 A 1A #NAME! 2
1 A 1A #NAME! 2
3 C 3C #NAME! 1
4 D 4D #NAME! 1


Based on this older thread below I have

Step 1: computed 1 = Concat ( supervisor, staff member)
Step 2: computed 2 = if (computed1 != next(computed1)) {1} else {0}
Step 3: sums on computed2

Old thread:

Sort data by Supervisor and Staff member.
Create computed column "computed1", concat (supervisor, staff member)
Create computed column "computed2", if (computed1 != next(computed1)) {1} else {0}
then do your sums on computed2


Source:

http://www.tek-tips.com/viewthread.cfm?qid=504605