getpossiblecount() to also count Nulls

[Anonymous]

Hi

Getpossiblecount() returns the current number of possible values in a field, however since null is not value per se it is not included in the count.

How can one get a count of possible values, including null ?

Best Regards,     Bill

[MK_QSL]

have you tried NullCount function ?

[tresesco · Accepted solution]

A trick just hits mind. Null count would be always one, right? May be you can add 1 to count conditionally like:

=If(Index(Field,null()),GetPossibleCount(Field)+1,GetPossibleCount(Field))

Or,

Simply like:

NullCount( Distinct Field)+GetPossibleCount(Field)

[Roop]

If you wish to count the null values you can probably do this some other way.

If they are a field in a fact table, you cannot really know whether each null is unique or not. If the nulls are in a reference table there must be some lind of other field for reference to count.

In either case it is quite often easier to add a field to the table with the content of 1 and then use sum ....

I hope this is useful

[Anonymous]

NullCount( Distinct Field)+GetPossibleCount(Field) works perfectly.

Many Thanks,     Bill