Home/ Questions/Q 1313
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-09-28T15:07:41+00:00

summary column in oracle apex interactive grid

  • 0
  • 0

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

oracle apexsum colomn
Share
Leave an answer

Leave an answer

Browse

3 Answers

  1. 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

  2. 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;
    }
});