3 Replies Latest reply on Jul 14, 2017 4:46 AM by Mihai Constantinescu

    Calculation - Filter Within LOD Expression string instead of 0

    Kevin Warren



      I need some help tweaking a calculation, within an expression (not filter shelf) to give me an "N/A" output for this specific example.


      Simple Desired Output Example:


      Current Month
      Previous MonthCurrent Month - Previous Month



      I get my desired result when the "Comparison Parameter" filter is set to "Up to Date Month" = "N/A"

      When I change the "Comparison Parameter" filter to "Up to Date Month vs Previous Month" I get 0.


      Logically, if I am comparing my "Up to Date Month" which is returning "N/A" and subtracting anything, I want the result to yield "N/A".