dynamically compute Interactive Grid Columns in Oracle APEX

My New Course on udemy

----
my blogger

[Hussain]

i am unable to edit in comm field in interactive grid report

[_Wish]

This calculation just display on page only, but if click on save button, the calculated value does not store on database.

[alisaleh]

select EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO,
nvl(sal, 0) + nvl(comm, 0) as TOTAL

from EMP

---
Column Initialization JavaScript Function
--
function(options){
= {
dependsOn: ['SAL', 'COMM'],
calcValue: function(argsArray, model, record){
const sal = parseFloat(model.getValue(record, 'SAL') || 0);
const comm = parseFloat(model.getValue(record, 'COMM') || 0);
if(isNaN(sal) || isNaN(comm)){
return 'error';
} else {
return sal + comm;
}
}
};
return options;
}

[danilocacoango]

not working to save error ORA-01733: virtual column not allowed here help

[jamil]

Dear Sir, I am working oracle apex Product Build 23.2.4,
I have created master and details, when I add new row in the intractive grid the application change the prevouse row calculated Values to zero in the Total_Tax, Total_Invoice, and Grand_Total
And this is the following programing steps I am using in the intactive grid details to calculate Total_Tax, Total_Invoice, and Grand_Total
I create Dynamic actions on the Quantity field
Name : Total_Tax
When Event Change
Selection Type Columns
Column(s) QUANTITY, UNIT_PRICE, V_TAX_RATE
True
Name Get_Total_Tax
Action Set Value
Set Type PL/SQL Expression

(round(nvl(:quantity, 0) * (nvl(:unit_price, 0)), 2) * (nvl(:v_tax_rate, 0) /100))
I am using the same logic for calculating Total_invoice and Grand_Total

waiting for your valuable answer

Best regards
Jamil Alshaibani