khaled sawafteh
khaled sawafteh

khaled sawafteh

View Profile
  • 0
Contributor
Asked: 2020-09-28T15:07:41+05:30

summary column in oracle apex interactive grid

  • 0
Advertisement

I used the JavaScript code it does not work please give me an example to calculate sum from column (QTY) thanks

oracle apexsum colomn
    Advertisement

    4 Answers

    1. Vinish

      Vinish

      View Profile
      Enlightened

      Try this:

      Provide a static id to your grid, for example, igemp, then execute the below JavaScript code using a DA:

      var model = apex.region("igemp").widget().interactiveGrid("getViews", "grid").model;
var n_qty, n_totqty = 0;
col_qty = model.getFieldKey("QTY");
model.forEach(function(igrow) {
    n_qty = parseInt(igrow[col_qty], 10);
    if (!isNaN(n_qty)) {
        n_totqty += n_qty;
    }
});
      • 0
    2. abumahmoud

      abumahmoud

      View Profile
      Contributor
      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_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

      • 1

    You must login to add an answer.

    Advertisement