Basic Table - Column Rule - Results are not consistent

Question

Hi All,

I have added a column rule to the Basic Table tool whereby if the field value does not equal zero, the font color is red. However, the rule is not applied consistently. In the example below, the field value for record 2 should be red. Other records are correct.

column rulerecord 2 is not correct

weilingwong · Answer

@Raj

1) I ran the workflow that you had modified (not my original workflow) and the result is as per the screenshot below. For record 3, the font color should be black when the value is zero.

2) I added back the field Company to the table. For record 20, the font color for the Company should be black.

3) When I ran my original workflow, all the results are correct if I do not select to Group by Company but not when I Group by Company.

Raj · Answer

@weilingwong please match the configurations as this work for me perfectly.

2.png

1.png

weilingwong · Answer

Hi Raj. Thank you. Unfortunately, the result is still wrong. I ran the workflow. For record 3 below, the font color should be black if the value is zero.

Record 3 >> if value is zero, font color should be black