Linear Gauge expression, can this work?

[jim_chan]

Hi guys,

i am creating a straight table, and use a linear gauge in it. I want to show that if number of col A  is more than number in col B, then color Orange, else Gray color.

So , in the gauge setting, i change the segment 1 color calculated expression to:

if(sum(Actual_Count) < (sum({<STATUS={'Failed'}>}MY_COUNT)),RGB(51,153,255),RGB(255,102,102))

It is not working. Anytime wrong guys?

Rgds,

Jim

[Anonymous]

Hi Jim

Could you post your app to help understand your issue?