Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 09, 2017 at 06:19 PM

    If you want to always have sum of some members - don't use local members, use hierarchy parent (in additional hierarchy) or use dimension member formula!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2017 at 06:09 PM

    By "However, if an entity lacks one and it does not appear in the report, the formula disappears." you mean that you use "Remove empty or zero records"?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2017 at 06:27 PM

    Thank you for answering! Could you give me an example of a dimension member formula that might be good for my situation?

    Add comment
    10|10000 characters needed characters exceeded