Edit Formula
In the Rules Builder, select Variable=Formula option from the submenu to display the Edit Formula dialog box.
| Element Name | Description |
|---|---|
| Variable Name | Enter a name for a variable. The variable is created in the input spreadsheet, if the Variable Type is Spreadsheet Variable. Because these variables are written back to the input spreadsheet, existing variable names cannot be used For more information about variable names, see also the |
| Formula | For more information, see the topic. |
| Variable Type | Specify the type of variable that should be created by the rule. For more information about variable types, see also the |
| Spreadsheet Variable | Select this option button to create a new variable in the input spreadsheet |
| Temporary Variable | You can create a variable to store an intermediate result. These variables are discarded and are not stored in the input spreadsheet |
Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.