I've been searching for issues related to numbers rounding on OBI Publisher on the forum and on the Web but since I'm a noob on it I really need a hint.
I'm performing a SUM on my database (SQL Developer) and on the Data model which the result is correct - 7053 - but when I bring the list of elements to Publisher and add it to a table or Pivot it rounds the values over 0,6 to 1 and the ones below it returns as blank!
That is causing me 136 of difference from the raw query to the publisher.
How can I stop this rounding? I have changed the Data Format and the Formating Mask on the Properties of the field.
On the picture below (image 1) you can see that on a regular table since I ordered it ascending the numbers lower than 0,5 returns as blank, the Pivot table is more giving when visualizing but when editing the report still when you actually run it, the rounding up still occurs (image 2).
Report in Excel
Can anyone help me out PLEASE? lol I have been pulling may hair (not may left) the whole week but no luck so far... (sucks being a noob).
Thank you guys.
A good friend Gareth have taught me how to fix see below what worked:
1. Open the report in edit mode
2. Select the Properties icon at the top of the window
3. Select the formatting tab
4. Scroll down to the bottom
5. At the end you will see a setting labeled 'Use 126.96.36.199 compatibility mode'. Set this property to TRUE
6. Select ok and save the report.
7. Retest Issue
Or apply patch: Applying Patch 14630670: UPDATE FOR BI PUBLISHER ENTERPRISE 188.8.131.52.X SEPTEMBER 2012