I am finding that when I use a Count function the records with Null values are not getting counted.
e.g. Table has
ID Column 2
If I count ID and group by Column 2, the Null values are not included so the total record count is now incorrect.
The result I get is:
I have a workaround which was to first replace all the Null values with “Blank” before doing the Count but wondered if there was a parameter I was missing.