Hi All,
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
1 A
2
3 B
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:
A 1
B 1
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.
Regards,
Dave