Export decimal value

mmostacchi

Hi,
I'm trying to export a decimal value in text format. I format the value in this way "Format(value,0,2)"; exporting by report I find always the decimals (for example if my value is 550, in the exported file I find 550.00), but If i do the same in xml export doesn't works; I find 550. Can you help me?

mohana_cse06

Try Format(value,0,9); for xml

mmostacchi

No way, doesn't works also with Format(value,0,9)

tothszabolcs

check this post:
viewtopic.php?t=22625&f=23

Its working for me:

d - Export::OnBeforePassVariable()
d := FORMAT("<G/L Account>"."Balance at Date",0,'<Precision,3:5><Standard Format,2>');

Result:
...
<BalanceAtDate>402 644 192,52</BalanceAtDate>
<d>402644192.520</d>
...

mmostacchi

Thanks, now it's working...
Best regards.

aniish

you can use this as well, it will also work

String := format(DecimalValue,0,'<Precision,2:3><Standard Format,0>')