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

@PREVSIBLING inside @SUMRANGE

Received Response
10
Views
3
Comments
edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

@PREVSIBLING inside @SUMRANGE

Content

Hello Experts,

I am implementing a logic where Year total at budget is equal to Actuals of specific period & then budget of remaining months.

Code Below:

"YearTotal" = @SUMRANGE(Budget,{BudStMth}:Dec) + @SUMRANGE(Actual,Jan:{ActEndMth});

Here i have taken BudStMth & ActEndMth as run time prompts. My requirement is that i want to remove one rtp so that user has to enter only one value say BudStMth. I tried to use @PREVSIBLING function to implement the same some thing like below:

"YearTotal" = @SUMRANGE(Budget,{BudStMth}:Dec) + @SUMRANGE(Actual,Jan:@PREVSIBLING({BudStMth}));

But on validation i am getting the below error:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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