Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a Pivot table to compare two plans and I would like to highlight the difference between them.
To do that, I tried to use the inter-record function 'Before' to calculate the difference bwn two plans ('Delta') and I wanted to use this 'Delta' in the text colorization expression.
Unfortunately, I got a mistake in both cases, when referring to the 'Delta' variable, and when using the formula for it.
Do you know if there are any limitations on using inter-record functions in Expressions?
And maybe there's another way to highlight the difference between two compared plans?
may be this
if ('Delta' >0, green(), red() )