Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Grand total is not rounding off in OAC Classic Report
In OAC Classic Report Grand Total in Report Table View is not rounding off.
Column Data Type at Database (in table) = Number
Column Data Type in RDP = Double
Column properties set at classic report are :
Aggregation Set : Average
Expected output is 5 but getting 4.75 in attached screenshot.
Any input how to resolve same and what could be possible reason for this behaviour.
Regards,
Indra Sardana
Answers
-
Hi Indra,
Is this a union report?
Regards,
Siddharth Dang
0 -
No Siddharth this is not union report.
Regards,
Indra Sardana
0 -
Indra ,
Can you try with only that column and one more column and see the o/p
Thanks
Anirban
0 -
Hi Indra,
This works for me as expected in OAC Classic. Which view are you using Table or Pivot?
0 -
Anirban even with single column report same behaviour:
0 -
Hi Jahanvi,
That is Table View.
Regards,
Indra Sardana
0 -
Hi Indra, Alternatively you can try editing the formula to ROUND(expression,0).
But ideally the data format change should work.
0 -
Hi Jhanavi,
Tried rounding off also but its not working not able to find out what is root cause for this abrupt behaviour.
Regards,
Indra Sardana
0 -
Indra ,
for that column can you see if Report based total option is checked or not along with Average .
Thanks
Anirban
0 -
Hi Indra, Di changing the column to measure in rpd help the grand total?
0
