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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.