Skip to Content
0

Local member issue on row axis with option zero values removed?

Feb 02, 2017 at 10:40 AM

39

avatar image

Hi Experts,

I have a profit center and account in row axis and time in column axis.

I have used remove empty and zero values on row axis .

I want to use local member on row axis for some calculation but it does not work when there is no specified account .

Can some one help me on how to achieve this? Thanks.

capture.png (17.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Feb 02, 2017 at 11:07 AM
0

Local members work only with data presented on the report!

In this case you have to create new member with dimension member formula!

Share
10 |10000 characters needed characters left characters exceeded
Srikanth Godavarthi Feb 02, 2017 at 11:26 AM
0

Hi Vadim,

Thanks for your reply, Is there any workaround for this other than dimension member formula?


Show 1 Share
10 |10000 characters needed characters left characters exceeded

No workaround!

If there is no cell on the report that is used in local member calculation then local member will be invalid.

And with remove zero and empty record any line can be removed, even account 4 :)

0