Error with Next month function in business rule by using "@MEMBER(@NEXTSIBLING([[getStartMonth({Scen
Summary:
Hi,
I am trying to get the next month in business rule by using "@MEMBER(@NEXTSIBLING([[getStartMonth({Scenario})]]))".
In the period dimension the hierarchy is like
Q1
Jul
Aug
Sep
Q2
Oct
Nov
Dec
Q2
Jan
Feb
Mar
Q2
Apr
May
Jun
If the Scenario's start month is Aug then the functions work properly and i get Sep as the next month. But if the Scenario's start month is Sep, then I get the below error Error:Error parsing formula for [FIX STATEMENT, at or after line: [" FIX (@MEMBER(@NEXTSIBLING("Sep")) : "Jun""]] (line 117): invalid argument in function []
The reason is because the next there is no Month sibling for Sep month as its Q2.