Home/ Questions/Q 571
In Process

vinish.ai Latest Questions

  • 2
  • 2
Asked: 2020-09-12T01:31:49+00:00

Sum Column Value Added in Item at Run time before pressing Save

  • 2
  • 2

I have created a master detail form by Item & Grid. Qty * Rate = amount. I want the sum of the amount to be in total amount. before pressing the save button. how can i do this?

https://apex.oracle.com/pls/apex/saidul_abc/r/master-detail10/login?session=107768956176789

User/Pass: demo/123

Share
Leave an answer

Leave an answer

Browse

18 Answers

  1. Give a static id to your interactive grid, for example, itemig.

    Then create a dynamic action on before submit event, or on the lost focus event of the quantity column in IG to execute the JavaScript code.

    You can use the following JavaScript code:

    var model = apex.region("itemig").widget().interactiveGrid("getViews", "grid").model;
var amtKey = model.getFieldKey("AMOUNT");
var totAmt = 0;
model.forEach(function(r) {
var n_amount = parseInt(r[amtKey], 10);
if (!isNaN(n_amount)) {
totAmt += n_amount;
}
});
$s('P2_TOTALAMOUNT',totAmt);

    Change the page items and grid columns according to your page items.

  2. hii i tried it is working for me, but facing a problem when using the format mask. I am using  format mask in the which i need to sum , when i am adding the value first time it appears without format mask and i could able to see the total in page item .But when i am adding second row the first row appears with format mask and it is not takin for calculation. Is there any way to take the total of column if it is having format mask.

    thank you

  3. Here I am facing a problem. When I press the tab and go to the new row, sum is reading it in Total.It doesn’t work unless i add a new one.

    https://apex.oracle.com/pls/apex/saidul_abc/r/master-detail10/login?session=9701677566396

    User/Pass: demo/123

  4. This answer was edited.

    I did everything. It just works when I am pressing the enter button. But when i Pressing the tab button it does not work.Or when I click on qty or rate column with the mouse, Total is working.   How can i solve this ?

     

    https://apex.oracle.com/pls/apex/saidul_abc/r/master-detail10/login?session=9701677566396 User/Pass: demo/123

  5. Finaly I couldn’t do the job. Tried all the way.
    I wanted, When i change Qty and rate Column (Qty*rate=Amount) then
    :P4_total amount will hold Sum amount. Only Change event.

  6. Because the formatted string is containing comma that is why it is not calculating. Below is the code in which I am replacing comma with a null value and using parseFloat() method to parse the numeric value.

    var model = apex.region("itemig").widget().interactiveGrid("getViews", "grid").model;
var amtKey = model.getFieldKey("AMOUNT");
var totAmt = 0;
model.forEach(function(r) {
var n_amount = parseFloat(r[amtKey].replace(/\,/g,""), 10);
if (!isNaN(n_amount)) {
totAmt += n_amount;
}
});
$s('P2_TOTALAMOUNT',totAmt);

  7. hi Vinish

    I did that and I got the total on Screen … OK

    but how I got this value to variable or another item to make validation or so . thanks

  8. This answer was edited.

    How I do “COLUMN1  * COLUMN2 =  COLUMN_X ”  IG report

    **not from SQL Query because it’s very complicated**