Introduction :
This post details the steps that required to calculate sum of 2 or more fields using function.
Steps to follow
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()))
);
}
Call To Action:
For Oracle apex development and customization please do visit our company website https://doyensys.com/
Conclusion:
With this above method user can sum n number of fields.
