You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

If @PREVSIBLING returns null, have it return the member being evaluated instead. Is this possible?

Accepted answer
41
Views
2
Comments

Summary:

Is it possible to return the current member being evaluated in @PREVSIBLING if the formula evaluates to null (the member being evaluated does not have a previous sibling)?

Content (required):

I am trying to write a calculation script that calculates a quarter-to-date true-up. It is simple to do this when the period is month 2 or 3 of the quarter, but for month 1, I need to be able to just calculate directly on the current month. See an example below:

"BU1" =

(@SUMRANGE("BU4"->AC1"->"TP1",&Act_QtrMth1:&Act_CrMth) * "Alloc_Pct") -

@SUMRANGE("BU1"->"AC_BU1_Alloc"->"TP1",&Act_QtrMth1:@MEMBER(@PREVSIBLING(&Act_CrMth))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!