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
Skip to content
  • Register

    • Error while converting RTP To Smartlist Value

    in EPM Platform and Freeform 4 comments

    Summary:

    We have a requirement where we're updating smartlist values based on form POV through RTP using function :

    "Tgt_Dept1" = @CalcMgrDoubleFromString(@SUBSTRING(@ALIAS({RTPDepartment}, SLAliases), 7));

    The function is working fine for 3 dimensions i.e. Account, Department & Projects but for CBS Dimension the Smartlist is populating some weird numbers instead of the members from RTP.

    The full command we're running is as below:

    "Tgt_Dept1" = @CalcMgrDoubleFromString(@SUBSTRING(@ALIAS({RTPDepartment}, SLAliases), 7));
    "Tgt_Proj1" = @CalcMgrDoubleFromString(@SUBSTRING(@ALIAS({RTPProject}, SLAliases), 7));
    "Tgt_GL1" = @CalcMgrDoubleFromString(@SUBSTRING(@ALIAS({RTPAccounts}, SLAliases), 7));
    "Tgt_CBS1" = @CalcMgrDoubleFromString(@SUBSTRING(@ALIAS({RTPCBS}, SLAliases), 7));

    All the Smartlist members have been tagged with Smartlist of type members. PFB the output we're getting from the above calcscript.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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