This dialog box is commonly used when you add custom datasets or add custom attributes, and you want to use a Calculated type of dataset or attribute.
The Equation Editor has the following components:
- Tree structure — displays an updated list of all the production datasets that exist in the Production editor, as well as the numerical attributes that exist in the Attributes tab. This includes custom-calculated datasets, custom-input datasets, custom-input attributes, and custom-calculated attributes. Clicking an item in the tree structure inserts it into the formula.
- Inputs / Units pane — displays the units associated with each input.
- If a dataset or attribute is displayed in an equation twice, only one unit can be associated with that variable.
- The table / grid displays a list of datasets / attributes in the formula pane when you click the Update Grid button, after you enter a valid formula. You can also update the table / grid each time you make a modification to the formula by clicking the Update Grid button.
- Note that if your formula is invalid, clicking OK or Update Grid displays an error message in the lower left corner of the dialog box.
- Calculator — consists of numbers and mathematical functions.
- Formula pane — displays the formula as you create it.
- The output unit is the unit associated with the output of your formula.
- By clicking the four icons directly above the formula area, you can insert subscript, superscript, and symbols within the formula.
- You can use both the on-screen calculator (by clicking the buttons in the dialog box) and your keyboard.
| Tip: | When entering a formula, make sure to add the closing “)” when using a function that opens with a “(“. If your formula is invalid, clicking OK displays an error message in the lower left corner of the dialog box. |
Referencing other datasets / attributes
You can enter a formula into the Formula pane using the keyboard. To reference another dataset or attribute, you must use the following format:
- Attribute: [A:Attribute Name]
- Dataset: [P:Dataset Name]