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!

How to use an Aggregate in a Computation on an Interactive Report?

Joe RSep 20 2012 — edited Sep 24 2012

version 4.0.2.00.07

Hello,

I'm trying to create a computation on an Interactive Report from the Actions menu to compute a percentage.

I have two Status columns, one for open and one for closed. I have to count the number of open and count the number of closed and then divide the two.

I created an aggregate, count, on the open status and closed status, but how to use them in the computation? There's no 'count' in the Function list in the Compute box.

I was hoping that those aggregated columns would be displayed in the Compute sub-menu on the Actions button but they don't appear to be.

Can someone help me with this?

Thanks,
Joe

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2012

Added on Sep 20 2012

#apex-discussions

3 comments

517 views