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.