Hi,
I'm using APEX v18.2 and I have rows in my Interactive Grid table where users are entering numeric values for each day of the week. I would like a Weekly Total column which calculates and displays the weekly total based on summing up the values for the individual days of the week. I would like this to update as soon as the user has entered a value for one of the days and tabbed out. The table is as below:
| Item | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Weekly Total |
|---|
| Apples | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 70 |
| Pears | 20 | 10 | 10 | 10 | 20 | 20 | 20 | 110 |
| Oranges | 2 | 4 | 3 | 12 | 4 | 10 | 10 | 45 |
The items rows are not always fixed and the user could add x number of rows depending on how many items they have on order. Currently this column is for display purposes only and I will not be doing anything else with the Weekly Total value.
My question is, how can I achieve this requirement in APEX. I have tried to follow a couple of posts (below) but not had any luck in implementing this. I would be grateful if someone could please outline the main steps or point me in the correct direction of similar examples.
Interactive Grid Cookbook - Dynamic Total Column page
https://jeffkemponoracle.com/2016/04/declarative-tabular-form-dynamic-totals/
https://www.youtube.com/watch?v=eHWtpukGyUE - Oracle APEX | Calculate Tabular Form [Rows & Columns] by JS
Regards