Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

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

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses
khaled sawafteh
khaled sawafteh

khaled sawafteh

  • 4 Questions
  • 6 Answers
  • 0 Best Answers
  • 41 Points
View Profile
  • 0
khaled sawaftehContributor
Asked: January 13, 20222022-01-13T14:48:30+05:30 2022-01-13T14:48:30+05:30

calculate sum in iteractive grid

  • 0
Advertisement

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);

Advertisement

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

Advertisement

i need refresh summation where i select delete before commit.

thanks in advanced

Advertisement

sum in apex
  • 0
  • 38
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer
    Advertisement

    You must login to add an answer.

    Forgot Password?

    Advertisement

    Sidebar

    Ask Question
    Write a Tutorial
    Advertisement

    Recent Blog Posts

    • Vinish

      Oracle LENGTH()

    • Vinish

      Oracle INSTR() Function

    • Vinish

      Oracle INITCAP() Function

    • Vinish

      Oracle Concat

    • Vinish

      Oracle CHR Function

    Advertisement
    Advertisement

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • Image to Base64
    • PL/SQL Beautifier

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