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

      Hello,

       

      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
      1064
      N/A6N/A

       

       

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