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.
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.