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???

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

• ###### 1. Re: How do I embed a Quick Table Calc (% Diff) into an IF Statement???

Hi Justin, can you share a packaged workbook? And do you expect that calculation to give you 300000%? I doubt that would give you more than 100%.

• ###### 2. Re: How do I embed a Quick Table Calc (% Diff) into an IF Statement???

Hi Justin,

the below example i am showing % difference of months, above 50% as green and below as red.

please find attached workbook for reference.

• ###### 3. Re: How do I embed a Quick Table Calc (% Diff) into an IF Statement???

Thanks, Sreekanth!  Work as I'd hoped.

Much appreciated

J