mibuso.com
Home› NAV/Navision Classic Client
Options

Formatting Decimal Numbers When Exporting as Plain Text

Matt.HillMatt.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

  • Options
    dav_IDdav_ID Member Posts: 4
    Hi,

    try using the format-expression like:

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

    Best regards
  • Options
    randrewsrandrews 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>');
  • Options
    dav_IDdav_ID Member Posts: 4
    Yes, that may be even better.
  • Options
    Matt.HillMatt.Hill Member Posts: 32
    All working now, thanks! =;
Sign In or Register to comment.