Exclude a value from a formula

[danialier]

Hello,

I want te following formula to exclude the value "n/a". What should I put ?

=count({<Id>}DISTINCT(Id))

Thanks,

dani

[crusader_ · Accepted solution]

Hi,

Try this:

=count({$<Id-={"n/a"}>} DISTINCT Id)

Hope this helps.

Andrei

[PrashantSangle]

Hi,

Which field gives you N/A

Try this,

Count({<Id-={'n/a'}>}Distinct Id)

or

count(if(not wildmatch(Id,'n/a'),Distinct ID))

Regards