Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF statement set numeric value

I'm having a problem with a if statement. It's seems simple but not or I'm making a mistake. 1 field (whole number) : Response tag The new column is   Status_SLA_Response = IF(VALUE([Respons...
Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago

    Anonymous  not ideal but can you +0 to the end of it and see if that fixes it?

vinaypugalia's avatar
vinaypugalia
Resolver I
7 years ago

Hello Anonymous ,

 

This actually looks wierd. Might need more details though.

In the mean time, please try the below options - 

1.  IF([Response Tag]>0,0,1)

2. IF([Response Tag]<=0,1,0)

 

Hope, this will help!