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!

Calculate the average on a report by column

658699Oct 7 2008 — edited Oct 7 2008

Hello~
I have several reports within several regions on a page. I have columns for Time,Count,Total, and Average. I am trying to figure how to calculate the average for the data that is displayed. For example:

By Time

Time Count Total Average
2 2 4
5 2 10
10 3 30

-----
17 7 44 6.2857

What is happening right now is that the app is averaging each row first then adding the average column. Is there anyway to average by the totals and not the rows?

Thanks
Deanna

Edited by: Dclipse03 on Oct 7, 2008 10:00 AM

This post has been answered by Tyson Jouglet on Oct 7 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2008

Added on Oct 7 2008

#apex, #apex-discussions, #plsql, #sql

11 comments

1,172 views