I have tried writing this below codes but i did not the get the count of nulls.
IF STR([Division]) = 'null' Then 'A' ELSEIF [Division] = 0 THEN 'B' ELSE 'C' END i am getting the counts for zero not for nulls.
Please help in getting to solve.
Your calculation assumes NULL values are strings with the value 'null' but if you try and convert a NULL to a string it's still NULL not 'null'
IF ISNULL([Division]) Then 'A' ELSEIF [Division] = 0 THEN 'B' ELSE 'C' END
Retrieving data ...