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?