CSPro Users Forum

Hi Josh or who can help,
I would like to to know the total number of members who are 5yrs and older in a roster (S1Roster) and pass it to variable (s2aSize).
I came up with this

s2aSize = totocc(SEC1000 where s1q4a > 5);

s2aSize = count(SEC1000 where s1q4a > 5);

It did not work, any help pls

Hi Justices,

It will be like
s2aSize = count(s1q4a where s1q4a > 5);

Regards
Vipul

Thanks for the response Vipul
Did not solve my issue i want the counted value assigned to (s2aSize)
s1q4a is in a different section as a roster and (s2aSize) in another non roster

You can't use totocc with a where clause so you should use count instead. Count takes the name of the dictionary record rather than the name of the group. Try replacing SEC1000 with the name of the repeating record that contains the variable s1q4a.