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!

How to recalculate the sum of a column based on the value of another column in IG

Hello experts,
Im using APEX 20.1. I have an IG with 2 columns: DataType and Amount
My current situation is:
image.pngMy need is:
The calculation of the sum must take into account this condition
IF (DataType == 'A' OR DataType == 'B' ) THEN - Amount
Else Amount
What's expected
image.pngThank you for help.
Comments
Post Details
Added on May 9 2022
#apex-discussions
5 comments
395 views