SECTIONSFormula Syntax
This page provides information about the different options that you can use when building a formula in Extended Planning and Analysis. For more information about formula syntax errors, see Plan Errors.
Operators
Operators are used to perform simple mathematical operations between two segments. Here is a description of the operators available in formulas.
Functions
Functions enable you to aggregate the values of cells that match the specified criteria. The cells can belong to the current plan or another plan.
In Extended Planning and Analysis, formulas have the following syntax:
Here is a description of the functions available in formulas.
| Function | Text Mode Syntax | Description |
|---|---|---|
| Average | AVG | Returns the average of cells that match the specified filter criteria. |
| Count | COUNT | Returns the total number of cells that match the specified filter criteria and contain a value. |
| Maximum | MAX | Returns the highest value among the cells that match the specified filter criteria. |
| Minimum | MIN | Returns the lowest value among the cells that match the specified filter criteria. |
| Sum | SUM | Returns the total of cells that match the specified filter criteria. If only a single cell matches the filter criteria, the value of the cell is returned. |
Here is a description of the function arguments.
| Argument Position | Required | Description |
|---|---|---|
| 1 | No | The name of the plan that the function references. You can use this to retrieve values from another plan. |
| 2 | No | Only accepts true and false. Determines whether to include any cells retrieved by the filter that are themselves are formulas. When true, the formula cells are included, when false they are excluded. When the argument is omitted, it defaults to false. |
| 3 | No | The filter criteria used to retrieve cells. If you omit this, all the cells in the plan are retrieved. For more information, see Filters. |