Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Bashar,
Try this
count({<prog_action = {'ADMT','MATR'}>}emplid)
-- Regards,
Vishal Waghole
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