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);
summary column in oracle apex interactive grid
abumahmoud
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:
thank you
See less