on 2015 Jun 26 5:11 PM
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!
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 41 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.