2 Replies Latest reply on Mar 28, 2013 4:28 PM by user1146711

    Grouping with Null

      Hello All

      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