@PREVSIBLING inside @SUMRANGE

@PREVSIBLING

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: