Can A Variable Be Used In GetCell Method Within A Category Advanced Function? (Doc ID 1526828.1)

Last updated on MAY 02, 2016

Applies to:

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

Goal

Can the Calculated Advanced Function getCell method use "a variable" instead of "a name of a category" as the argument within Primavera Portfolio Management?

Eg:
var financialCategory="PM Estimate IT Amount ";
var fiscalYear="FY13";
var var_category = financialCategory+fiscalYear;
var result=getCell(var_category).Value;
return result;
 
Is there any systematic approach that can be done to loop through a series of Categories without hard coding them in the calculation?
 

Solution

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 hundreds of Community platforms