Formula Syntax

The formula syntax used in columns and rows in Extended Planning and Analysis is similar what is used by Excel. Operators are used to perform simple mathematical operations between two segments. The table below contains the available operators.

Operators Available in Formulas

Operator	Description
+	Adds the second segment to the first segment.
-	Subtracts the second segment from the first segment.
*	Multiplies the first segment by the second segment.
/	Divides the first segment by the second segment.
^	Raises the first segment to the power of the second segment.
( )	Groups mathematical operations together to establish precedence.

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.

The following is the list of available functions.

Function	Text Mode Syntax	Description
Average	AVG	Returns the average of cells that match the specified filter criteria.
Count	COUNT	Displays the counts of the total number of cells in a range that contains a number.
Maximum	MAX	Displays the maximum value of a cell.
Minimum	MIN	Displays the minimum value of a cell.
Sum	SUM	Displays the total of the selected range of cell values.

The following is the list of available formula options.

Formula Options	Description
Include Calculations	Includes the calculations related to a cell.

For more information about formula syntax errors, see Plan Errors.