Calculating Sum of 2 or More Fields in Oracle Apex

Step 1:
Create
all the items which you need to calculate
Step 2:
In
items level
Element
à HTML Form
Element Attributes
à Call a function on Key up
onkeyup=”total();”
Step 3:
Create
the function in page header level
function
total()
{
$(“#P7_TOTAL_COST”).attr(“value”,
   
($(“#P7_EX_SHOW_ROOM_COST”).val().trim() == “” ? 0 :
parseFloat($(“#P7_EX_SHOW_ROOM_COST”).val())) +
   
($(“#P7_ROAD_TAX_LIFE_TAX”).val().trim() == “” ? 0 :
parseFloat($(“#P7_ROAD_TAX_LIFE_TAX”).val())) +
   
($(“#P7_REGISTRATION_CHARGES”).val().trim() == “” ?
0 : parseFloat($(“#P7_REGISTRATION_CHARGES”).val())) +
   
($(“#P7_OTHER_CHARGES”).val().trim() == “” ? 0 :
parseFloat($(“#P7_OTHER_CHARGES”).val())) –
    ($(“#P7_DISCOUNTS”).val().trim()
== “” ? 0 : parseFloat($(“#P7_DISCOUNTS”).val()))
);

}


By
A.Arun Kumar

  • December 29, 2016 | 15 views
  • Comments