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 calculate the column value based on the other column values in Oracle APEX?

Paul SusantoDec 15 2020 — edited Dec 15 2020

Hi All,

I am using Oracle APEX - 18.1.0.00.45
I have an Interactive Grid. In that IG I have 4 columns: say METAL_COST, METAL_WEIGHT, IS_METAL_FLAG, TOTAL_COST.
Now, when the User enter values for both the METAL_COST, and METAL_WEIGHT columns, then It should set the IS_METAL_FLAG column value as Y, and also set the TOTAL_COST as METAL_COST*METAL_WEIGHT .
In case if either of the METAL_COST, or METAL_WEIGHT columns has NULL or blank , then It should set the IS_METAL_FLAG column value as N, and should not calculate the TOTAL_COST.
image.pngCan you please guide me with your valuable suggestions.

Thanks & Regards,
Susanto Paul
This post has been answered by SmithJohn45 on Dec 15 2020
Jump to Answer
Comments
Post Details
Added on Dec 15 2020
#apex, #apex-discussions
5 comments
5,162 views