The Set of Formulas

There are more than 50 different formulas that allow for modifications such as: transforming text, performing mathematical calculations, applying conditions based on a field’s value, and many others.

Each formula has the same structure:

FORMULA_NAME ( PARAMETERS )

where the Formula Name is the name of the formula or function to be performed, and PARAMETERS, which are always placed inside parentheses, are the field names, values, or other nested functions required to execute the formula.

This function MATH() allows you to execute mathematical calculations, which will be described below.

An example of a nested function:

FIRSTUPPER (LOWERCASE(REPLACE({Color}, “red”, “Tinto” )))