truncated variable via script

Mon, 11 Jul 2016 13:28:06 GMT

Hello,

I am trying to load a set of variable via script. But, loading, it truncates each time a portion of the variable.

The variable load is a formula:

"sum({<TST_ID={0,1},[Type article Art]=-{"S*"},[AAAA DP]={"<=$(=$(vAnnéeInJour)-$1)"}>}[Coût financier Tra])"

In my scrip I tested several methods:

SET [vStock € A-x] ='sum({<TST_ID={0,1},[Type article Art]=-{"S*"},[AAAA DP]={"<=$(=$(vAnnéeInJour)-$1)"}>}[Coût financier Tra])' ;

SET [vStock € A-x] =sum({<TST_ID={0,1},[Type article Art]=-{"S*"},[AAAA DP]={"<=$(=$(vAnnéeInJour)-$1)"}>}[Coût financier Tra]) ;

In both cases, it removes the parts of the formula I or reference variables. I ended up with the text:

sum({<TST_ID={0,1},[Type article Art]=-{"S*"},[AAAA DP]={"<="}>}[Coût financier Tra])

Note: If I manually created the variable, it works flawlessly.

Does anyone know how to get around this?

thank you in advance

Re: truncated variable via script

sunny_talwar — Tue, 12 Jul 2016 10:30:10 GMT

The issue is with Dollar sign getting evaluated in the script... try this approach mentioned by Stefan here: