Thursday 29 December 2016

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

4 comments:

  1. Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete
  2. Such a nice blog, I really like what you write in this blog, I also have some relevant information about if you want more information.

    Big Data and Hadoop Online Training

    ReplyDelete
  3. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Spark and Scala Online Training

    ReplyDelete

  4. Iam so thrilled because of finding your alluring website here.Actually i was searching for Oracle APEX.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle SOA.Thank you soo much..

    ReplyDelete