Dear; I appriciate your co-operation in this forum. I use the following code which is get from this site to calculate sum in iteractive grid ------------------------------------------------------------- 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); ------------------------------------------------------------ i think in this statement var actionType = model.getValue(r,"ACTION_TYPE").v; -----error i need refresh summation where i select delete before commit. thanks in advanced
Discy Latest Questions
in oracle forms 10g there is trigger when_new_form_instance Excute_query what is the opposite to it in APEX thanks
Hi, Please is any way to install developer suite 10g r2 with windows server 2019
I used the JavaScript code it does not work please give me an example to calculate sum from column (QTY) thanks
Advertisement