Exluded Function

[suzel404]

Hi all,

I want to calculate the number of ID without TYPE_ID = 4 like this : Count(DISTINCT {<ID= E({<TYPE_ID={4}>} ID)>} ID)

But when I select an ID : 20133663 normally I have to see the unique selection but I cannot display it in the straight table.

Thanks for your help,

Regards

[sunny_talwar · Accepted solution]

Try this:

=Count(DISTINCT {<ID *= E({<TYPE_ID={4}>} ID)>} ID)

[suzel404]

Thanks you Sunny

It works fine !!