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!

Automatically calculate column X based on column Y value in Interactive grid

Souzan-OracleJul 31 2019 — edited Aug 4 2019

Hello,

I am working on a IG which all columns are within the table, I am trying based on a column value “Commission” which is submitted/edited manually , to automatically calculate the “Rate” column = (commission value/52/40) for each of the Person.

I have tried in 2 different ways, but with no success :

  1. 1- Within the SQL while creating the IG, but gave me an error
  2. 2- With DA with set value but nothing is happening.

Can someone advise me how I can solve this?

Thank you in advance!

Souzan

IG.PNG
Comments
Post Details
Added on Jul 31 2019
#apex-discussions
2 comments
405 views