Creating Formulas

Formulas are created in the formula editor which is available on the Parameters tab for creating or editing derived property definitions and validations.

To create a formula:

1. You can enter a text formula or insert functions and properties in the following ways on the Parameters tab:

   • To insert a function, place your cursor in the formula and click Insert Function. A list of functions is displayed. Expand a function to view its input parameters. Enter the parameter values and click OK.

   • To insert a property, place your cursor in the formula and click Insert Property. A list of properties is displayed. Select a property and click OK.

2. Make selections from the following options:

   • Remove Spaces––Selected by default. If selected, all spaces in the formula are removed when the formula is evaluated and when the property is saved. To preserve spaces to be evaluated as literal values in the formula, disable this option.

   • To evaluate the formula, select an option:

     • Evaluate with Selected Node––Click and select a node. The node's current property values are used in the formula. Click Evaluate. The result is displayed at the bottom of the formula designer.

     • Evaluate with Scratch Pad––Enter property values manually. Values can also be copied from a node and then modified for the evaluation. In the Copy From Node, click and select a node to display its property values in the grid. Use the filter row below the column headings to filter the list of properties. Use the Edit buttons in the Action column to modify property values for evaluation with the formula. Click Evaluate. The Evaluation Result is displayed at the bottom of the formula designer.

3. To test the formula, click Evaluate.