A vertical function (advanced) is the same as an Advanced function. The difference is that when getChildren() (refer to the getChildren table in Methods) is used, the filtering specified on the dialog box is applied (only the open/closed/candidate items are returned).
Note: getDependsOnItems(); getSupportsItems (); and getSubItems() are not available.
The vertical function (advanced) is calculated from the portfolio's items for a portfolio of items, or from the portfolio's portfolios for a portfolio of portfolios on different categories. Each parameter represents an array of cells.
To define a Vertical Function (Advanced):
- Select the Data Source step of the Category wizard. The Data Source dialog box appears.
- Fill out the dialog box using the features described in the general Data Source Advanced Function Dialog Box.
- In the Operate On area you can define which items and portfolios will be included in the calculation of the vertical function (getChildren(...)). Check the checkbox of one or more of the following statuses: Open, Closed, and Candidates.