Metric in a script variable

[Anonymous]

hi

When I place the following function in a text object it works:

=num(Sum({<PaiTipoRegisto={'Proveitos'},FactDate = {"$(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,'0')&' K'

If you put it in the script with this format :

let vVar=

'num(Sum({<PaiTipoRegisto={'

  &chr(39)&'Proveitos'&chr(39)

  &'},FactDate = {"$(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,'

  &chr(39)&'0'&chr(39)

  &')&'&chr(39)&' K'&chr(39);

and in text objet:

     =$(vVar) or

     =$(=vVar)

i got 0 (zero)

what is wrong ?

best regards

Ricardo

[vinieme12]

Try

let vVar='num(Sum({<PaiTipoRegisto={' & chr(39)& 'Proveitos' & chr(39) & '},FactDate = {"$(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,0)' & chr(39)&'K';

or

let vVar = 'num(Sum({<PaiTipoRegisto={' & chr(39)& 'Proveitos' & chr(39) & '},FactDate = {"$(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,' & chr(39)& '0' & chr(39) &') K';

[Aurelien_Martinez · Accepted solution]

Hi,

SET vVar = =num(Sum({<PaiTipoRegisto={'Proveitos'},FactDate = {"%(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,'0')&' K';

LET vVar = replace('$(vVar)', '%', '$');

[Anonymous]

Almost

LET not set.

LET vVar = =num(Sum({<PaiTipoRegisto={'Proveitos'},FactDate = {"%(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,'0')&' K';