Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I found this answer elsewhere:
counts A when B is null
counts A when B is not null
And both of these work perfectly.
What I'm trying to do now is count A when both B AND C are null.
=count({$<={"=isnull(B)","=isnull(C)"}>}) didn't work.
=count({$<={"=isnull(B)"},={"=isnull(C)"}>}) also didn't work.
Anyone know the syntax? Or is this not possible?
Thank you
yes that would be wise, since you are running into the difference between missing values and table nulls.
You can see some about the different use cases here:
No luck either
Returns everything as if the set weren't there
It would do that if that combined set isnt there. are you sure there are cases where both are null?
Yes, but if it matters, they are nulls due to relationships. A, B, and C are three different tables that are all related on one key field. The nulls are because that key value doesn't exist in another table.
I'm wondering if creating a fact table would resolve my issue.. may be wise to do that anyway
yes that would be wise, since you are running into the difference between missing values and table nulls.
You can see some about the different use cases here:
Ooh, that's a very nice PDF in that URL, thank you. I was always on to the fact that there were multiple types of "nulls", but that document explains it nicely. I'll give the fact table a try!