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:
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:
