How to add a where clause to a variable definition

[bashar_f]

Hi,

I have a variable called vAdmissionsCount

The definition is supposed to be

count(emplid)  Where prog_action = ADMT or MATR

prog_action is a field, but when i enter the definition like this, I get red lines all over.

[tresesco · Accepted solution]

=Count( {<prog_action={'ADMT','MATR'}>}emplid)

[PabloOrtiz]

Try this

=Count( {<$(vAdmissionsCount)>}emplid)

you have to create de var with this value

prog_action={'ADMT','MATR'}