Important: This section provides some guidance when working with Search Formula. It is assumed that you are familiar with SQL expressions.
- Text in single quotes 'hello world'
- Use || (double pipes) to concatenate
- Standard operators (+, -, /, *) to calculate
- No commas in numbers
- Enclose calculations in parentheses when concatenated with strings