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

    LoD calc generating nulls - how to avoid

    Jone Kutty

      Hi

       

      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])}

      END