If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

CSV Format Rounds Dollars to the Next Dollar

Started by ajferrara, 04 Aug 2005 08:53:27 AM

Previous topic - Next topic

ajferrara

I need to pull a report that exceeds 65K rows.  The only option I have is to save the report with a .CSV extension.  However, the dollar amounts are automatically rounding to the next dollar (283.56 = 284).  If I save the report as Excel/html, the dollar amounts show two decimal places.

Anyone know a work around this?

Thanks,

-A.J.