Conditionally format Totals function in Straight table

[Ashwinyp]

I want to apply conditional formatting on the Totals function of one column in a Straight table.

Bin	Expected	Actual	Expected%	Actual%	log(Actual% / Expected%) * (Actual% - Expected%)
1	35	33	25%	20%	0.01
2	61	74	44%	45%	0.00
3	25	36	18%	22%	0.01
4	19	20	14%	12%	0.00
					0.02

This is how my table looks. The total function here is 0.02 and I would like to change its text/background color based on an "If" condition, like if(total>0.25, red(), green()). But I'm unable to do it. I have tried using dimensionality()=0 and rowNo()=0 but it does not work.

Can someone please help?

[y_grynechko]

Hey, it is not going to be easy to do but it is possible:

Script logic:

Used if statement: