Skip to Content

Problems with sum local 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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 02 at 12:35 PM

    Incorrect idea to use local member in this case!

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

    Add comment
    10|10000 characters needed characters exceeded