Post reply

Exporting Currency Table Drops Trailing Zero

  • March 26, 2010 at 9:45 am

    #146234

    We build a data feed consolidating products into simple tables and exporting to tsv files for import by 3rd parties. Several of the columns are of type currency and when they are exported, during the export the trailing zero is dropped which is causing problems at our 3rd parties.

    For example, 5.20 becomes 5.2.

    Is there a way to not drop the trailing zero?

  • March 30, 2010 at 9:33 am

    #1142362

    I would look at the source and any transformations along the way to make sure you have the scale and precision set properly on those columns. You might also add data viewers to try to track down where the data is going bad.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply