Formula Builder

The Formula Builder lets you interactively define a Formula Expression.

How it Works

1. ExpressionBuilder

Example

To build that formula:

1. The "Order Amount" field was chosen, inserting order_amount
2. The Operator "* Multiply" was chosen, inserting *
3. The "Related to Customer" field "Discount" was chosen, inserting related_to_Customer.discount
4. The entire expression was enclosed in single quotes
5. The [Check Syntax] button was clicked, to ensure validity.

{{Note: When comparing to strings, include the string in double quotes.
E.g. .name = "ABC Co."}}