In one of the reports due to security reasons the user wants a cell to be' NULL' for a certain state and for a specific category since it is below certain number and i was able to get that. I am using a grouping on the same report on the category column which has (a,b,c,d,e values) saying it as total and that is showing me NULL now and i understand it is happening because anything group with NULL is also a NULL, instead i want to show the actual number there. Please advise how i can get that.
Also i tried using 0 instead of Null to see what will i get for the category Total ( which is grouping) i am getting 0 so not sure what should i do here to get the actual numbers.
Edited by: user1146711 on Mar 5, 2013 4:00 PM