Scenario:
You are creating a calculated field, you have an expression like this:
Then i tried
IF( someField1 < 1 AND someField2 > 0, 'yes',
IF(someField1> 5 AND someField2 < 4, 'yes', 'no'
)
)
When you hit validate, the validation fails, it says the The expression was only partially recognized. What to do in this situation?
Solution:
- AND needs to be all lowercase - and
- You need to include table names for the fields. Best way to make sure your field will be recognized is to double click on it in the fields panel while your editor is open. It will add the field with table name directly into your expression.
- The whole expression needs all to be one line
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now