3 Replies Latest reply on Oct 24, 2016 1:32 AM by justin.nathan.1

    How do I embed a Quick Table Calc (% Diff) into an IF Statement???

    justin.nathan.1

      I am using a Quick Table Calculation to show the percentage difference in [Number of Records] across different months.  The table calculation is this:

       

      (ZN(SUM([Number of Records])) - LOOKUP(ZN(SUM([Number of Records])), -1)) / ABS(LOOKUP(ZN(SUM([Number of Records])), -1))

       

      I am trying to create a KPI that would show whether the sum of the calculation above is greater than ABS(300).  I have tried to get this into an IF Statement however I have not had much success.

       

      Any help with this would be appreciated - no doubt there's an obvious workaround that I haven't thought of.

       

      Thanks

       

      J