Script with Substring failing
Summary:
Content (please ensure you mask any confidential information):
Hi all
We have this script with Subscring which is failing:
FIX ("Input","FCCS_Periodic", @RELATIVE("IFRS7_ReceberNC", 0), @RELATIVE("Total Custom1", 0), @RELATIVE("Total Custom2", 0), @RELATIVE("FCCS_Intercompany Top", 0), @RELATIVE("Total Contributory", 0))
"FCCS_ClosingBalance_Input"(
"Form" = "FCCS_ClosingBalance" -> @SUBSTRING(@NAME(@CURRMBR("Account")),0, 5) ;
)
ENDFIX
=================================================
This is the error:
Cannot calculate. Essbase Error(0): Error compiling formula for [FCCS_ClosingBalance_Input, at or after line: [""Form" = @SUBSTRING(@NAME(@CURRMBR("Account")),0, 5) -> "FCCS_ClosingBalance" ;"]] (line 9): unknown member name [@_SUBSTRING] in function [operator @X]
Could someone let me know if I can missing any parameter? This format works in Planning.