Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=count(if(Emp_LE <=35, [Employee Number]))
=count( Distinct if(Emp_LE <=35, [Employee Number]))
Or count({<Emp_LE = {"<=35"}>} distinct [Employee Number])
S.
Hi,
Try this expression without if
=count({<Emp_LE ={'<=35'}>} DISTINCT [Employee Number])
Regards,
Jagan.
Dear TheVilla,
=COUNT(DISTINCT If(Emp_LE <=35, [Employee Number]))
Kind regards,
Ishfaque Ahmed