Basic Table - Column Rule - Results are not consistent

[weilingwong]

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

[Yoshiro_Fujimori]

Hi @weilingwong ,

I cannot recreate the issue on my side.

Is it possible to give us a sample workflow which causes this issue?

(You may mask the data where necessary)

[weilingwong]

Hi. Sample workflow is attached. The result for record 3 is not correct.

[Raj]

@weilingwong 
small change made and this is working now
please find attached

[weilingwong]

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

[Raj]

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

[weilingwong]

@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.