Sunday, July 7, 2019

Saved Search Formula: Rules when Working with Strings and Numbers

Important: This section provides some guidance when working with Search Formula. It is assumed that you are familiar with the implementation of SQL expressions.

Rules:

  • Text in single quotes
  • Use || (double pipes) to concatenate
  • Standard operators (+, -, /, *) to calculate
  • No commas in numbers
  • Enclose calculations in parentheses when concatenated with strings

 

 

 

No comments:

Post a Comment