About Custom Functions

You access custom functions from the function selector in Calculation Manager condition, script, and formula components.

Custom functions allow you to perform tasks such as copying and exporting data, removing and adding single or double quotes to a text string, comparing two strings, converting a date to the YYYYMMDD format, among other tasks.

You can use custom functions in Planning business rule components.


In some custom functions, the parameter may have a drop down with a selection of "year". If you have a dimension or member in your application named "year", using the custom function with the selection of "year" will not validate. This could be an issue for any parameter selection (not just "year") that is also a dimension or member name.

To work around this issue, after selecting "year" from the parameter’s drop down, in the rule, add @name( ) around it, so that it shows as: @name(year).