topic Re: Comparing values between 2 columns in table for color expression in App Development

Comparing values between 2 columns in table for color expression

Fri, 17 Mar 2017 11:00:15 GMT

I have a table with the years as columns and the client name as rows. I now want that the text color is green when the sales are higher than previous year and red when they are lower.

There is also a totals column which I want to remain black.

Someone who have done this before?

Thanks in advance

Re: Comparing values between 2 columns in table for color expression

sunny_talwar — Fri, 17 Mar 2017 15:25:16 GMT

You seem to be doing this in a pivot table, right? You can use Before/After function to compare one year to another year. Take a look here:

Missing Manual - Before() and After()

Re: Comparing values between 2 columns in table for color expression

Fri, 17 Mar 2017 15:35:30 GMT

Thanks, it worked!

Do you have an idea how i can exclude the totals this color function?

Re: Comparing values between 2 columns in table for color expression

sunny_talwar — Fri, 17 Mar 2017 15:47:43 GMT

You can use Dimensionality() function to exclude the above color calculation for totals

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()