Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Oracle
  • Oracle Apex
  • Python
  • Questions
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Add Post
  • Oracle
  • Oracle Apex
  • Python
  • Questions
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  1. Asked: September 28, 2020

    summary column in oracle apex interactive grid

    abumahmoud

    abumahmoud

    • 0 Questions
    • 1 Answer
    • 0 Best Answers
    • 28 Points
    View Profile
    abumahmoud Contributor
    Added an answer on November 1, 2020 at 3:49 am
    This answer was edited.

    Hi, also you can solve it for debit or credit values, i.e. as follows: var model = apex.region("test_ig").widget().interactiveGrid("getViews", "grid").model; var totAmount = 0; var vSign = parseFloat(-1); model.forEach(function(r) { var actionType = model.getValue(r,"ACTION_TYPE").v; var v_jdAmountRead more

    Hi,

    also you can solve it for debit or credit values, i.e. as follows:

    var model = apex.region("test_ig").widget().interactiveGrid("getViews", "grid").model;
    
    var totAmount = 0;
    var vSign = parseFloat(-1);
    
    model.forEach(function(r) {
    var actionType = model.getValue(r,"ACTION_TYPE").v;
    var v_jdAmount = parseFloat(model.getValue(r,"JD_AMOUNT"));
    
    if (!isNaN(v_jdAmount)) {
    if (actionType == 'C') totAmount += v_jdAmount;
    if (actionType == 'D') totAmount += -1*v_jdAmount;
    console.log("it is "+ actionType + " " + v_jdAmount);
    }
    
    });
    $s('P33_TOTAL',totAmount);
    
    

    thank you

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

Sidebar

Explore

  • Ask Question
  • Add Post

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us