Oracle Communities

Oracle Analytics and AI

Child Item

Grand total is not rounding off in OAC Classic Report

Indra Sardana-Oracle

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

Find more posts tagged with

Analysis

Accepted answers

All comments

SiddharthDang-Oracle

Hi Indra,

Is this a union report?

Regards,

Siddharth Dang

Indra Sardana-Oracle

No Siddharth this is not union report.

Regards,

Indra Sardana

Anirban Basu-133546

Indra ,

Can you try with only that column and one more column and see the o/p

Thanks

Anirban

Jahnavi-Oracle

Hi Indra,

This works for me as expected in OAC Classic. Which view are you using Table or Pivot?

Indra Sardana-Oracle

Anirban even with single column report same behaviour:

Indra Sardana-Oracle

Hi Jahanvi,

That is Table View.

Regards,

Indra Sardana

Jahnavi-Oracle

Hi Indra, Alternatively you can try editing the formula to ROUND(expression,0).

But ideally the data format change should work.

Indra Sardana-Oracle

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

Anirban Basu-133546

Indra ,

for that column can you see if Report based total option is checked or not along with Average .

Thanks

Anirban

Jahnavi-Oracle

Hi Indra, Di changing the column to measure in rpd help the grand total?