In Web Intelligence reports, custom formatting #,##0.00 is applied to values such that
- 1000 should appear as 1,000.00
- 500.5 should appear 500.50
- 500 should appear as 500.00
However, integers less than 1000 do not appear to have the custom formatting applied to them, when CSV archive is opened by Excel (by default).
- 1000 appears as 1,000.00
- 500.5 appears as 500.5
- 500 appears as 500
SAP BusinessObjects Business Intelligence Platform 4.0
SAP BusinessObjects Business Intelligence Platform 4.1
format mismatch, export as CSV archive , KBA , BI-RA-WBI , Web Intelligence , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.