You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PBCS member formula

in EPM Platform and Freeform 2 comments

Hi all,

I have a scenario to reference value from same dimension(Measurement) in member formula.

Measurement

Global_Assumptions

Worker_Type (SmartList values : Internal_Emp,Contingent_Worker,External_Offshore,External_Onshore)

Worker_Hours_Per_Day

Worker_Hours_Per_Week

Resource_Type (SmartList values as below)

Internal_Emp

External_Offshore

External_Onshore

Member formula is being written for Worker_Hours_Per_Day as follows

IF("Worker_Hours_per_Week" != #MISSING)
"Worker_Hours_Per_Day" = "Worker_Hours_per_Week" / 5;

ELSE
IF("Worker_Type" == "ContingentWorker")

"Worker_Hours_Per_Day" = "Worker_Hours_Per_Week"->"No Cost Centre" -> @Member("External _Offshore") /5;

Wanted to pick up value associated with Member External_Offshore 40 hours value available in intersection (Worker_Hours_Per_Week, No Cost Centre, External_Offshore combination). When I use @Member("External_Offshore") in member formula, the validation is throwing an error, "Cannot reference member from same dimension using cross dimension reference).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!