Group By drops Blank values

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
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.



Hi Dave,

null (empty) values are ignored for counting, but not for grouping. I tried the same calculation and I see all the groups, including the empty value. Am I missing something?

I’m using version 3.9.5. Which version are you using?