To follow:
- The formula field type should be same as the expected result
Example: (Formula (Text), Formula (Numeric)……).
Example: Formula (Text) => CASE WHEN ({total} > 1000}) THEN ‘Qualified’ ELSE ‘Not Qualified’ END.
- Use ‘ ‘ if the formula is displaying the text result.
- The calculations should be written into the parenthesis.
- For Concatenation use double pipes ||.
Wild Cards: (%, _)
Wildcards are used to find the string comparison and perform pattern matching
Example: Formula (Text) => CASE WHEN {location} LIKE “% Kerala %” THEN ‘Kerala Present’ ELSE NULL END