Skip to Content
avatar image
Former Member

Local members in totals, with nil/zero values removed

Hi,

I am trying to build a report that we will be able to use for a number of different companies.

Within the report are a number of sub-totals, for which I have created local members.

In addition, there are further sub-totals which include some of the above local members, i.e. local members which are adding up other local members.

This works when all zero/empty values are kept, however I need to be able to remove these for presentational purposes.

If I change the formatting to remove rows with empty/zero values, some of the local members I created disappear. This then causes my other local members to show #VALUE if they were set up to add up local members which have now gone. (Instead, the local member formula has automatically changed and is now including the column axis, i.e. time).

I have included all accounts (including empty ones) in the local member formula so that when we switch between companies the report picks up all accounts, without having to edit the report.

I am new to BPC, is there a way to get around this?

Thanks,
Clare


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2015 at 04:52 PM

    Hi Clare,

    Local members work with Excel cells and if some are missing - you get #VALUE error.

    You may try to use:

    1. Additional hierarchy nodes (may be in additional hierarchy)

    2. Dimension member formulas to sum subtotals

    3. Some complicated formulas in local member to work with ranges (not clear without report sample).

    Vadim

    Add comment
    10|10000 characters needed characters exceeded