Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Maria_m
Partner - Contributor
Partner - Contributor

Using inter-record functions in colorization expression

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?

Labels (1)
1 Solution

Accepted Solutions
brunobertels
Master
Master

may be this 

if ('Delta' >0, green(), red() )  

View solution in original post

1 Reply
brunobertels
Master
Master

may be this 

if ('Delta' >0, green(), red() )