Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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