2 Replies Latest reply: Mar 28, 2013 11:28 AM by user1146711 RSS

    Grouping with Null

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

      Thanks
      Ravi

      Edited by: user1146711 on Mar 5, 2013 4:00 PM