Script with Substring failing

Jul 9, 2025 10:05AM

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.

Script with Substring failing

Howdy, Stranger!