Script with Substring failing — Cloud Customer Connect
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

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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