Table Tool - Format a cell based on change from previous column

[Newt]

I would like to highlight Table entries that have large percentage changes from the entry in the previous column.

In the example below, Jet Skis and Wet Suits have large percentage drops in Q4 from the Q3 value.

Is there a Formula syntax for the Table formatting that would evaluate the change from the Q3 column to Q4, in order to determine whether the Q4 value should be highlighted?

Thanks for any help!

	Q1	Q2	Q3	Q4
Jet Skis	30	31	32	25
Pool Noodles	10	10	11	12
Chlorine	12	12	13	13
Scuba Snorkels	6	5	5	5
Scuba Fins	5	6	7	8
Knives & Weights	3	3	3	3
Regulators	9	9	10	9
Wet Suits	40	41	39	30
Air Tanks	25	26	25	24

[Yoshiro_Fujimori · Accepted solution]

@Newt ,

For configuring table style rules, you may want to check this page.

https://help.alteryx.com/current/en/designer/tools/reporting/table-tool/table-style-rules.html#style...

Here is a sample workflow. Hope this helps.

Workflow

Table Tool Configuration

Output

[Newt]

Thank you.  I was unsure of the syntax...

...and when I typed your solution into the existing column rule I had set up earlier, it turned the whole table yellow.

I had to delete the table tool and start fresh for the solution to work.

The table tool is one on those Alteryx tools that can get confused by earlier commands & settings.

Thanks again!