Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Applying Column formatting rules to dynamic columns

Wrigley510
6 - Meteoroid

Hi,

 

I'm attempting to have the Table tool format certain values in a table when they hit a particular threshold. 

 

Some background- I am doing some 6-week forecast reporting and the column headers will be dynamically changing week-over-week. I have followed the instructions in the walkthrough below to get the Unknown/Dynamic formatting to apply to the data in each column, but I am getting the following error 'The field "*Unknown" is not found in the record' and the data is not being formatted. 

 

(https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Apply-Column-Rules-to-Multiple-Columns-in-th...)

 

Any help would be appreciated.

13 REPLIES 13
camarieschmidt
5 - Atom

Any update on solution? I am having the same issue.

Ramesh_Y1987
5 - Atom

Is there any update on solution for this, since i am encountering the same issue for my workflow

 

melissa_m
8 - Asteroid

Looking for a solution as well...

IntlTaxGuy16
5 - Atom

Using the formula option as shown in the attached image worked for me. 

 

tonumber([_CurrentField_])<0

 

Labels