Count if and set analysis

[D19PAL]

Hi,

what’s the best way to do the following.

Count all employees

If(count({<field = {yes}, field2 = {no}>}counter) = 1,1,0)

I need to do aggr counting all the employees where there’s a 1 in the IF statement.

the expression is to go into a table with 1 row of data, I don’t want to add the employees field, hence I think I’ll need a aggr.

thanks

[MayilVahanan]

Hi

Try like below

Sum(Aggr(If(count({<field = {'yes'}, field2 = {'no'}>}counter) = 1,1), Employees))

or

Sum(Aggr(If(count({<field = {'yes'}, field2 = {'no'}>}Distinct counter) = 1,1), Employees))