My Oracle Support Banner

Can a Variable Be Used in the 'GetCell' Method within a Category Advanced Function? (Doc ID 1526828.1)

Last updated on JANUARY 16, 2020

Applies to:

Primavera Portfolio Management - Version 8.0 SP2 and later
Information in this document applies to any platform.

Goal

Is there any way to let Primavera Portfolio Managment loop through a series of Categories without hard-coding them in a Calculated Advanced Function - for instance, by having the getCell method use a variable instead of specifying the name of a Category as the argument?  For example:

var financialCategory="IT Capital";
var fiscalYear="FY13";
var var_category = financialCategory+fiscalYear;
var result=getCell(var_category).Value;
return result;

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.