The Advanced Functions Editor dialog box provides you with a tool to easily create and edit functions. To access the Advanced Functions Editor dialog box, click 
from the Data Source dialog box (refer to Advanced Function and Vertical Function (Advanced).
You can type your advanced function directly into the Script area, and/or select values from the Expression Builder and Properties List. The Advanced Functions Editor dialog box includes the following fields:
- Expression Builder: Select the values in the Expression Builder area and click
to add the values to the function in the Script area.- Method: The values available in the Method drop-down list are dependent on whether you are creating an Advanced Function for cell value (items and sub-items), or for a summary value (portfolios).
- Indicator: Select an indicator from the drop-down list. This field is only available if you select the getIndicator method.
- Category: Select a category from the drop-down list.
- Value List: Select a value list from the drop-down list.
- Value: The values available in the Value drop-down list are dependent on the Value List you select.
- Properties List: The Properties List contains Object Properties that are relevant depending on the syntax used. Objects appear in bold in the list followed by their Properties. To insert a Property to the script, double-click the Property, or select the Property and click .
- Script: In this area, enter the function. The function is comprised of JavaScript and unique PPM syntax, as described in Advanced Function Syntax.
- Test Button
: Enables you to test the function you are defining for a category. For more information, refer to Testing a Function.