Formatting Decimal Numbers When Exporting as Plain Text

Matt.Hill

I'm exporting a report as a plain text file, however, any decimal values that are generated appear as '123.4' (for 123.40) or 500 (for 500.00). Is it possible to have the correct number of decimals added as part of the FORMAT command being used to generate them?

Thanks

dav_ID

Hi,

try using the format-expression like:

FORMAT(ExportValue,0,'<Sign><Integer><Decimals,3>')

Best regards

randrews

If I got it right - you want to make 2 digits after dot:
FORMAT(ExportValue,0,'<Precision,2:2><Sign><Integer><Decimals>');

dav_ID

Yes, that may be even better.

Matt.Hill

All working now, thanks! =;