How to Add Where Clause to a Variable Definitions

[bashar_f]

Hi,

I have a variable.called [vAdmissionsCount]

I'd like this variable to be defined as

count(emplid)  Where prog_action = ADMT or MATR

prog_action being one of the fields, I get red lines all over, what am I doing wrong?

[VishalWaghole]

Hi Bashar,

Try this

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

-- Regards,

Vishal Waghole

[er_mohit]

Try this

count(distinct  if(wildmatch(prog_action,'ADMT','MATR'),emplid))

here distinct  keyword gives you the unique records means count single empid if it comes repetative