Formula issue

[Sa743liz-]

Hi I'm trying to write this formulas but is showing an error. Can you help me? 

[Luke_C · Accepted solution]

Hi @Sa743liz- 

Check the data types of each of the fields, it looks like some of the fields might be text fields which would prevent you from doing a check on if they are less than .2 or 1. You could put a select tool in front of the formula to change their type.

[MattBSlalom]

The syntax appears to be correct, so if @Luke_C's suggestion doesn't resolve your issue, please attach a sample workflow so that we can better diagnose any other problems.

[Emmanuel_G]

@Sa743liz- 

Have you made sure that the PP % change fixed charge field is of numeric type? Or that all the fields you compare to numbers are indeed numeric?

[Qiu]

@Sa743liz- 
Just like everyone suspected, I think it might your data type of input not being numeric.
I replicated your formula in the Formula tool and it works just fine.

[Sa743liz-]

Thank you so much for all of your answers it was a data type problem.