Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

@HspNumToString - error in Calc Manager Script

YannisVJun 5 2018 — edited Jun 6 2018

Dear all,

I am trying to copy data from BegBalance to the months for salaries. "START_MONTH" is an account type smart list.

My smart list has the same names as the months, when I run the script it gives the following error even though it validates ok:

Error executing formula for [SALARIO_ATUAL] (line 3): invalid argument in function [@_BPROC]

Can you please help?

Below script:

fix("2019","Jan::Dec","Orcado","Trabalho","Cargos_NA",

@relative("Empresa",0),@relative("Employee",0),@relative("Entity",0))

"SALARIO_ATUAL"(if(@ismbr(@member(@HspNumToString("BegBalance"->"START_MONTH"))::"Dec"))

"SALARIO_ATUAL" = "SALARIO_ATUAL"->"BegBalance";

endif)

endfix

pastedImage_11.png

pastedImage_14.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2018
Added on Jun 5 2018
5 comments
907 views