Flag creation help

[mahitham]

Hi,

Can any one please help me on below flag creation

When Rate is greater than Threshold then its Pass else its Fail.

I have tried like below f([Pass Rate]>[Red %],'Pass','Fail') but getting all 'Fail' records under Flag.

Please help me on this.

Thanks in advance

[Uday_Pasupuleti]

Try converting the Threshold into % format and try your if statement

[raman_rastogi]

Convert both pass rate and Red Values into same data format like if you are considering [Red % ]value in % so make sure Pass Rate should be %.