Check out the full documentation on available formulae by browsing the complete list of calculation expressions.
We have a library of examples available for showcasing what you can do with calculation fields.
You must select a format for displaying the expression result.
- Text - Use this for displaying text or unknown values.
- Number - Use this only for displaying numeric values.
- Date - Use this for displaying formatted date values. The value should be in the following format:
- Currency - Use this for displaying formatted currency values. The value should be a number and you'll need to select a specific currency.
You can enable verbose error reporting in the app when building or troubleshooting complex expressions by setting
SHOWERRORS(true). Another useful way to interactively test expressions is to use the
eval() function in combination with a text field and
INSPECT(). This allows you to type in your code and immediately inspect how it is being evaluated.
Setting Up An Eval Calculation
Evaluating A Calculation