Skip to Main Content

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-Interactive Grid Calculate Row3 value based values in Row1 - Row2

user1.0Feb 26 2018 — edited Mar 2 2018

I'm new to Application Express.

I have an interactive grid.

I need to be able to use the value in a column in row 1 and the value in a column in row 2 to calculate the value in row 3.

Users will enter values in rows 1 & 2

Row 3 is automatically calculated (before the page is saved)

Row 3 is read only

EX:

Row 1 amount = 1000  <user entered>

Row 2 amount = 100   <user entered>

Row 3 amount = 900

I'm guessing I need a dynamic action on my amount column.

How do I identify the row number and then get the corresponding value in my amount column?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2018
Added on Feb 26 2018
4 comments
1,886 views