need help for If condition

[antonybi]

Hi All,

I need your quick solution on this below if condition as its not working as expected.

Suggest if I'm anything wrong.

Look forward for your quick response.

Thanks,

[sunny_talwar]

May be this

If('(KPI_RAG1)' = 'NA', 1, 0)

[antonybi]

Thanks Sunny for the quick response.

But still It's not working. expected result is 1.

PFB for your reference.

[sunny_talwar · Accepted solution]

My bad, I missed the $ sign

If('$(KPI_RAG1)' = 'NA', 1, 0)

[antonybi]

Hi Sunny,

Then I'm getting the below error.

Error: Error in expression ')' expected.

I think I forgot to add = in my variable. Now I did the same looks like working fine.

Thank you!