cancel
Showing results for 
Search instead for 
Did you mean: 

What is the proper Calculated Dimension Member Syntax

0 Kudos

I feel pretty stupid asking this but I haven't had to create a calculated member in quite a while.  If its available can someone provide a link to any documentation or guide me in my formula.

Here is what i'm trying to do. Sum 3 projects as Project A.   We don't want to create a new hierarchy for this so we hoped it could be done in a calculation. 

Project A equals the sum of Project B, Project C, Project D.

We are on BPC 7.5 MS

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

cecilia_petersson2
Active Participant
0 Kudos

Hi Crowl,

Assuming your dimension name is PROJECT, in the Formula field for Project A write: [PROJECT].[Project B] + [PROJECT].[Project C] + [PROJECT].[Project D].

/Cecilia

0 Kudos

Thank you Cecilia!

Answers (0)