Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Make an Invoice data entry page with Interactive Grid

Habib BysonJan 7 2017 — edited Jun 2 2017

Hi,i created a page in my application using interactive Grid in apex 5.1. the IG have 3 columns (QUANTITY, UNIT_PRICE, TOTAL), and a textbox name P1_GRAND_TOTAL.

i want to perform this calculation  on each row (  TOTAL= QUANTITY * UNIT_PRICE )  and get the sum of TOTAL columns in all the rows  into P1_GRAND_TOTAL textbox. The calculation should be fired,

only if i change the column value of  Quantity or Unit Price.

how can i archive this?

i try to use the solution in this tread,https://community.oracle.com/thread/4003463#comments  to get total cloums sum updated, but i always get zero values after sum it up.

Thnaks.

This post has been answered by Mahmoud_Rabie on Jan 9 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2017
Added on Jan 7 2017
15 comments
3,324 views