Skip to Content
avatar image
Former Member

Formatting for Row and Column Local Member intersection

Hi BPC Friends,

I am trying to implement formatting for one our reports in v 10.0 as below ,tried several ways but not successful .

The issue is formatting H48 and I48 different to row F and G 48 . Our expected result is to hide H48 with white format and I48 as a text without percent . Columns H and I are local members and row 48 is a local member.

Right now I have given formatting on local members selecting them individually in dimension member/property formatting

May I get some suggestions for achieving this

Thanks,

Krishna

fomatting.png (23.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 07, 2016 at 04:41 PM

    Sorry, but not clear!

    You can use formula in the local member for row 48 to check the column and for H column use "" and for I column - some required text...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      Hi Vadim,

      I have taken a better explained screenshot now, the requirement is cell I20 should show subtracted value of Scenario(G)and Budget (H) and all other cells in this row 20 should show a divided values as in the formula. This appears to be local member limitation, I am trying several ways but the light still didnt stirke

      lm3.jpg

      lm3.jpg (160.8 kB)
  • avatar image
    Former Member
    Nov 08, 2016 at 06:28 AM

    Hi Krishna,

    Have you tried it this way?

    formatting-sheet-lm.png

    lm-output.png

    Regards,

    JP

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi JP,

      Thanks for the your suggestion and appreciate the effort you have taken to answer this.

      Both your and Vadim's suggestions are helpful , I have to tweak the solutions to accomplish this.

      I will get back on how I did this soon .

      Thanks,

      Krishna

  • Nov 25, 2016 at 04:40 PM

    Looks like you don't understand what I am writing!

    Your local member formula has to be something like:

    Column I is column number 9.

    =IF(COLUMN()=9,Subtract,Divide)

    Is it clear?

    Add comment
    10|10000 characters needed characters exceeded