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!

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2017

Added on Jan 7 2017

#apex-discussions, #interactive-grid, #invoice

15 comments

3,835 views