2 Replies Latest reply on Apr 1, 2016 12:02 PM by Derrick Austin

    LoD calc generating nulls - how to avoid

    Jone Kutty



      I am using following table calc - this is simple representation of what I am trying to do in my use case. I am trying to select one date from order dates and want to pull sales data.


      Once I select date, I get right information, however, the result also generates nulls for the dates which are not selected, so when I plot this, it tries to plot nulls.


      is there a way to write this formula differently? I do not want to plot nulls.


      if [Order Date]=[Date] then

      { fixed [Order Date], [Product Category], [Product Sub-Category]: sum([Sales])}