Adding a Formula
The Add Formula component enables you to create and save a new formula. The formula can then be used in the Expression Builder to create more complex calculations. To access the Add Formula component, navigate to the Formula Overview, and select Add from the Actions menu on the component header. You can also add a new formula from the Formula Summary component by selecting Add New from the Actions menu on the component header.
You can enter information in these fields:
Click in a field and enter information as needed. Values are required in the Formula Name and Expression fields.
In the Expression field, enter a formula using standard python commands and syntax (see Supported IronPython Functions). Calculations can include conditional statements and these mathematical operators: + - / * ^ == != <> < <= > >= ( )
When you select a value in the Entity field, the system filters the values available for selection in the Field box to only fields from the selected entity or its child entities. When you make a selection in the Field box, the system enters the selection in the Expression field and clears the value in the Field box. You can select additional entities and fields as needed.
When you are finished, click the Save button. The system displays a message to confirm that your changes were saved and displays the new formula on the Formula Summary.
