Skip to Main Content
Forums

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!

APEX 18.1 - SUM distinct in Interactive Report

mikeTelSep 27 2018 — edited Sep 27 2018

Hi Gurus,

Is there's a way to to a SUM (distinct) in a report?

Screen Shot 2018-09-27 at 4.41.49 pm.png

Basically, say, I have this 2 column report that is group by a certain field.

I want to SUM the Parent column based on a distinct value and the Child column as per normal.

I can see that the build-in aggregate function has distinct on Count but not on Sum.

Screen Shot 2018-09-27 at 4.44.05 pm.png

How will I achieve this?

thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2018
Added on Sep 27 2018
#apex-discussions
1 comment
232 views