Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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))

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question