Load Script is not converting a number

[brunolelli87]

Dears,

The following code is not properly converting the number to Currency.

Money#(Money(@25,'R$ #.##0,00;-R$ #.##0,00',',','.')*1000,'R$ #.##0,00;-R$ #.##0,00', ',', '.') as LOPP

 

But, after loading the script, I can Change it on Chart Properties > Number > Money

So, my question is:
How can I convert it without need to do those 2 steps. I want to convert it via LOAD Script.

How can I do it?

Thanks

[tabletuner]

You might be helped with using the notation settings in the doucment properties. Changes you make there will be valid for the field in the whole document.

[Or]

Why are you using Money#() on Money() in the first place? You should be able to format using just Money()?

Money(@25*1000,'R$ #.##0,00;-R$ #.##0,00',',','.') as LOPP