How to sum 2 columns in Interactive grid in Oracle APEX(1) using PL/SQL Expression
Вставка
- Опубліковано 7 вер 2024
- Sum 2 columns SAL,COMM to new column Total
create dynamic action:
event:
when sal,comm change
action:
setvalue :PL/SQL expression:
nvl(:SAL,0)+nvl(:COMM,0)
affected elements: Total
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
I am wondering if you do 'items to submit' 'QUANTITY,UNIT_PRICE,V_TAX_RATE' under ' PL/SQL Expression' in the Action True Setting.
Or you use wrong round syntax. Suggest you separate the 3 columns and see if you can get the value respectively. Thank you for following my channel and asking.