My Oracle Support Banner

Oracle BI EE Report:Configure 'Grand Total'[Column Measure-Aggregation Rule] To Show 2 Decimal Value (Doc ID 2125166.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On :  11.1.10.0.0 version, Analytics

ACTUAL BEHAVIOR  
---------------
Customer has a custom field of type Currency but without Decimal places.
When a report is built and an aggregation applied, the aggregated value shows 3 decimal places.
Even on applying a Data Format on the Column to specify 2 decimal places, the aggregated value shows 3 decimal places.

EXPECTED BEHAVIOR
-----------------------
The Aggregated value should use the Data Format specified for the column and show 2 decimal places.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Select a Standard Object (say Opportunity) or create a Custom Object
2. Create a new Custom Field of type Currency but without Decimal Places specified.
3. Expose the field on SUI and enter a value with 3 decimal places
4. Build an Analysis in BI on the Custom Field and apply an aggregation rule of Sum on it
5. Apply a Data Format on the column and specify Currency with 2 Decimal places.
5. Run the Report in BI by clicking on 'Results' tab.

Observe that even though the Data Format of Currency with 2 Decimal places is applied on individual values for each record, the Aggregated Value of the custom field displays the value with 3 decimal places.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the Data Format is not applied on BI Report for Aggregated Custom Fields.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.