Using inter-record functions in colorization expression

Maria_m — Fri, 25 Aug 2023 08:12:41 GMT

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?

Re: Using inter-record functions in colorization expression

brunobertels — Fri, 25 Aug 2023 09:49:27 GMT

may be this

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

topic Using inter-record functions in colorization expression in App Development

Using inter-record functions in colorization expression

Re: Using inter-record functions in colorization expression