Mathematical Operands in Expressions
Operands specify the values that an operator uses to produce a result. The following table explains the types of operands supported in Financial Reporting.
Table 50. Operands
Type of Operand | Examples |
|---|
Literal | 3, 0.0, 27.5, 65.334, -841 |
Row or column reference number | [1], [4], [8], [A], [C:D] |
Cell reference number | [2, E], [E, 2] Note: This cell reference addresses row 2 column E. |
Functions | Average, Min, Max |
Scoping | Grid1.row[3] |
In the following row formula, which multiplies the values in row 3 by 100, the row reference [3] and 100 are both operands:
[3] * 100