Formatting Decimal Numbers When Exporting as Plain Text

Matt.Hill
Matt.Hill Member Posts: 32
edited 2005-02-04 in NAV/Navision Classic Client
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

Comments

  • dav_ID
    dav_ID Member Posts: 4
    Hi,

    try using the format-expression like:

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

    Best regards
  • randrews
    randrews Member Posts: 135
    If I got it right - you want to make 2 digits after dot:
    FORMAT(ExportValue,0,'<Precision,2:2><Sign><Integer><Decimals>');
  • dav_ID
    dav_ID Member Posts: 4
    Yes, that may be even better.
  • Matt.Hill
    Matt.Hill Member Posts: 32
    All working now, thanks! =;

Categories