Evaluates the result of a rule provided as a string.
Indirect([Rule Text])
Where
Rule Text is the rule in the form of a string which will be evaluated and its result returned.
| Rule | Meaning |
|---|---|
| Indirect("DWVariableQuoteItem" & ItemReturn) | When ItemReturn results in 2 the result will be the value of the Variable DWVariableQuoteItem2 |
| Indirect("IF(DWVariableQuoteItem" & ItemReturn &"<2,""A"",""B"")") | Will evaluate the result of the Variable DWVariableQuoteItem 3 (When ItemReturn results in 3) and return A if it is less than 2 otherwise will return B. |
| Indirect("Item" & MyNumber(-1)) | When used in a cell on the second row of a Calculation Table will return the value coming from the Item column and row 2. |
The function MyNumber will return any number used within an owners name.
The function MyName will return the name assigned to the owner of the rule.
See Calculation Table - Absolute Cell Referencing to reference the name of a Calculation Table cell.