Skip to Content
avatar image
Former Member

Confusing Member Formula Result

Hi,

We are running BPC 10.0 Netweaver with a periodic model setup. I have a member formula setup for the OPENING_ASSETS account member formula that returns either the result of the previous input schedule ending assets or the result of the previous ending assets result.

The formula works find but for some reason periods 2015.04, 2015.07, and 2015.10 all show up blank under opening assets. I don't understand why these would be blank when the previous member is populated. I even tried populating both the ending_assets_inp and ending_assets in case it was pulling the value from the wrong one.

If someone can explain why this is happening that would be great.

IIF([TIME].CURRENTMEMBER.PROPERTIES("TIMEID")<[CATEGORY].CURRENTMEMBER.PROPERTIES("OPENING_PERIOD"),

([ENDING_ASSETS_INP], [TIME].PREVMEMBER),

([ENDING_ASSETS], [TIME].PREVMEMBER))

issue.png (35.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 16, 2015 at 05:22 AM

    Not enough info...

    Please test simplified:

    IIF([TIME].CURRENTMEMBER.PROPERTIES("TIMEID")<"2015.04",

    ([ENDING_ASSETS_INP], [TIME].PREVMEMBER),

    ([ENDING_ASSETS], [TIME].PREVMEMBER))

    Please explain other members you have on the report...

    Vadim

    P.S. Incorrect results on 2015.04, 2015.07, and 2015.10 may be due to the OLD SP for BPC and BW, please upgrade to the latest

    Add comment
    10|10000 characters needed characters exceeded