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.
Anyone know the syntax? Or is this not possible?
Solved! Go to Solution.
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
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!