Hi gurus,
Need quick help to understand if there is restriction in using @MDSHIFT in member formulas.
The version is 11.1.2.4.
The below code works completely fine in a CALC Script, however when same is used as member formula gives error on opening the data form containing this member - Form Invalid.
Below is the code used in member formula
Members - A (Store) and B(Dynamic calc) are in Accounts dimension .
IF(@ISMBR("Jan"))
"B" = @MDSHIFT("A",-1,"Years",,11,"Period",);
ELSE
"B"= @Prior("B",1);
ENDIF
Note: (Both members A and B are stored for purpose of calcscript ,however B is made as Dynamic calc when testing same code in member formula).
The code validates successfully in member formula editor, however gives error on opening the data form containing this member - Form Invalid.
The @Prior when used in member formula gives the expected result for all months except for "Jan" for each of the Years.
Note: The requirement is for several years and hence cannot use Substitution variable for Year.
Can anyone please validate the @MDSHIFT in member formula in your application and let me know if you face similar issues.
Need to know if this is a bug or issue with the script.
Appreciate your help.
Regards
SN