Local members in totals, with nil/zero values removed
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?