=count(DISTINCT(Id))

[danialier]

Hello,

I want to create a count formula that counts all IDs excpet the ones with " n/a ". So far I'm using

=count(DISTINCT(Id))

What else do I need to add so this fiormula is not counting the rows with " n/a " ?

Thanks,

dani

[#2 · Accepted solution]

Use set analysis to remove out the n/a

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

hope that helps

Joe

[tobias_klett]

Hello Dani,

do you have the 'n/a' in the Id field? Than it is:

=count({<Id=Id-{'n/a'}>} distinct Id)

Hope ths helps

Tobias

[danialier]

excellent, thanks Joe

[#5]

Hi Dani,

use below expression:

=Count({<Id={"*"}-{'n/a'}>}DISTINCT(Id))

Thanks

Sabal

[#6]

No worries, it is probably a good idea to have a look at these links for a more in depth overview of set analysis

Set Analysis: syntaxes, examples

Romancing with Set Analysis

hope that helps

Joe