Skip to Content
0

Problems with sum local member

Mar 02 at 12:24 PM

27

avatar image
Former Member

Hello,

I have a problem with the sum local member. I use:

=SUM(EPMSELECTEDMEMBERS(SOMEDIM))

The result is:

But there is a problem, the report sum all the members, calculated or no, without taking into account that it is a hierarchy and there are calculated components.

How could I SUM only the uncalculated members whose CALC = N property?

For “Capitulo 2” line, the correct sum is: SP018 + SPX30 -> 14.350.645 + 302.384 ->14.653.029

My system is BPC 10.0 NW. SP26

Thanks.

1.png (35.4 kB)
2.png (48.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Mar 02 at 12:35 PM
0

Incorrect idea to use local member in this case!

Use normal hierarchy parent in the existing hierarchy or create additional hierarchy.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Vadim,

I will use the hierarchy and leave the member of the hierarchy blank. Thanks!

0

"leave the member of the hierarchy blank" - ??? what do you mean?

0
Former Member

I changed the name for the member "Total XXXXX" for " ":

Thanks Vadim.

3.png (15.0 kB)
4.png (37.8 kB)
0