Skip to Content
1
Former Member
Jan 09, 2017 at 05:57 PM

How can I create a local member that totals selected cells dynamically?

89 Views Last edit Jan 19, 2017 at 04:22 PM 3 rev

Hi All,

I'm working with BPC version 10.0 SP 23. I've attached an "example" report to illustrate my issue.

I have a report in which users can select different entities via the page axis, and within the report is a local member that totals only certain items (items B, D, G indicated in red in my example.) This works fine if all of these items are present for each entity. However, if an entity lacks one and it does not appear in the report, the formula disappears. If I select a different entity that lacks item B, I still want the local member to sum items D&G. Guidance on this issue would be greatly appreciated.