Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle apex 19.1 - display profit percentage (%) in IR Report totals

ragu_sAug 7 2019 — edited Aug 15 2019

Hi All,

I am trying to display 'overall profit %' for my interactive report in totals row. Is their any way to do this or is this even feasible in interactive report. Any assistance will be really helpful.

Basically the calculation will be ROUND((margin/total sales)*100,1), for the case below the '%' will 73.4; the percentage (%) should be displayed even when we apply control break to columns similar to sum or count or avg.

pastedImage_0.png

Thanks,

Ragu

Comments
Post Details
Added on Aug 7 2019
7 comments
245 views