how to add distinct in this expression

[#1]

=count(if(Emp_LE <=35,  [Employee Number]))

[nagaiank]

=count( Distinct if(Emp_LE <=35,  [Employee Number]))

[shawn-qv]

Or count({<Emp_LE = {"<=35"}>} distinct [Employee Number])

S.

[jagan]

Hi,

Try this expression without if

=count({<Emp_LE ={'<=35'}>} DISTINCT [Employee Number])

Regards,

Jagan.

[engishfaque]

Dear TheVilla,

=COUNT(DISTINCT If(Emp_LE <=35,  [Employee Number]))

Kind regards,

Ishfaque Ahmed