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


Functions are available in the Member Selector and the Function Selector.