Conditional formatting not working in Table Tool

[Sohdaw]

Hi,

I have a data set where i have done multiple transformations and unioned to create a table.

The data is joined such that account numbers A / B / C is one table, and Grand Total is another table, and unioned together to form the below table.

My columns headers "Sum of ....." are dynamic and change daily. 

I have applied conditional formatting on table tool to each "Sum of ....." Column as well as Dynamic or Unknown Fields - Column Rules - using Formula ToNumber([_CurrentField_]) < 0 then set Text Color RED. 

However the odd thing is not all columns with values <0 are having the text as RED. 

Can you please enlighten me what is the issue? 

Account Number	Sum of 20-Jun-2023	Sum of 21-Jun-2023	Sum of 22-Jun-2023	Sum of 23-Jun-2023	Sum of 26-Jun-2023	Sum of 27-Jun-2023
A
B
C
Grand Total

Thanks 

[geraldo]

@Sohdaw 

When the report columns are going to be dynamic I usually create the formula in the Dynamic or unknow fields option. the new columns will inherit the rules.
I uncheck the columns in the select tool and create the general rules in this item and then I select all the columns again and the rules are automatically created

[Sohdaw]

I have the formula in both the columns "Sum of ....." and Dynamic or unknown fields. Can you share your workflow and how many table tool you have? 

[geraldo]

@Sohdaw 

Did you check if these fields that are not displayed in red are in bold, demonstrating that there is a rule associated with them?
Or if you don't have more than one associated rule that could be overriding the text color rule?

and check if all fields are being identified as a string because you are casting tonumber

[Sohdaw]

Don't quite get you - the fields that are not displayed in red are in bold. So there is a rule associated with them. But i cant figure out why the rule isnt working. 

Note that i have a row rules as well with the checkbox unticked (This Rule should override conflicting Per-Column Rules). 

[geraldo]

@Sohdaw 

If the sum columns only have the rule equal to dynamic or unknown fields you could place a select tool before the table tool and uncheck the sum columns run even if error and select again and run to see if it inherits the configuration of the unknown column

row rules can also affect the generation depends on the column selected in the rule

[Sohdaw]

I tried the steps you mentioned. Which i believe is similarly documented here. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Apply-Column-Rules-to-Multi...

But it is extremely odd that the conditional formatting only applies to a subset of my dynamic column and not the rest. ie the last few columns but not the first few which has values <0. Please send help. 

[geraldo]

@Sohdaw 

Only possible if you can send the workflow with sample data to analyze the problem

[caltang]

I was having this exact issue and I followed your steps by adding my formula in the Table Tool, then use the Select Tool before to uncheck everything and run. Then check everything, and voila it works!

Thanks a lot @geraldo !