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!

Condition on Compute sum

Sameh M. SewilamFeb 14 2018 — edited Feb 16 2018

Hi All,

Basic Info

APEX version 5.1
DB version, edition and host OS 11.2 /SE on Windows 7
Browser(s)/version(s) used 'Fire Fox'
UI/Theme Vista
Templates Hero
Region type Classic Report

I have a classic report for departments with average salary column with compute sum = Yes

I have created a checkbox using the following select

APEX_ITEM.CHECKBOX(p_idx=>1, p_value=>DEPT_ID) as select_dept

The question is how to make the summation of average salary for the checked departments only as shown in the below figure

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2018

Added on Feb 14 2018

#apex-discussions

2 comments

588 views