Problems with sum local member

[former_member341613]

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.

[former_member186338 · Accepted solution]

Incorrect idea to use local member in this case!

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

[former_member341613 · Accepted solution]

Thanks Vadim,

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

[former_member186338 · Accepted solution]

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

[former_member341613 · Accepted solution]

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

Thanks Vadim.