Table Tool # Edit Column Rule # Background Highlights missing

[Yuvaraja]

Hi Team,

I'm facing a problem in Table Tool at Edit Column Rule.

Hope small issue but unable to identify where i need to change the settings or inputs.

1. In my workflow "Ageing" days which will be varies depends on Since date vs Today's date.

2. Requirement is Ageing more than 5 days needs to be highlighted that's all,

3. I have updated the specific column rule, but output highlights only for values near by 5, which means 6, 7, 8, 9 some thing like that... but not highlighting for higher values 15, 18, 20...etc. 

Herewith i have attached Input sheet, Workflow & Output images.

Kindly provide your feedback and solution for this issue.

  

Thanks

Yuvaraja.

[zajaccount · Accepted solution]

Hi

I think it's because your aging column is of string data type - use  a select tool to change it to numeric and it works as expected:

[Yuvaraja]

Hi Zaj,

Yes i got it. Thanks for your inputs, i didn't think in data type perspective. Anyway thanks.

Regards,

Yuvaraja