Working with Functions
Use functions to define member formulas that return data values or members.
For example, you can use functions (and mathematical and logical operators) to return a list of siblings, parents, or children of a member you specify, to return a list of data values that are greater than or less than a value you specify, or to allocate data values from a member you specify. When you select a function, you are prompted to enter the correct parameters.
If you are working with Planning applications, you use functions in formula, script, condition, and member range components.
Following is a list of the types of functions you can use in Planning components:

Boolean

Relationship

Calculation Operators

Control Flow

Data declarations

Functional

Mathematical

Member Set

Range (Financial)

Allocation

Forecasting

Statistical

Date & Time

Miscellaneous

Custom
Note:
Functions are available in the Member Selector and the Function Selector.