How to calculate total & grand total in master-detail form with Interactive Grid in oracle apex

#masterDetail #Oracledatabase #OracleApex #Sql #PLSql #javascript
In this video, I have explained how to calculate total & grand total in master-detail form with Interactive Grid in oracle apex 20.2 in detail.
---------------------Facebook Link--------------------------------
/ namoraapexify
------------------Master-Detail Form--------------------------------------
• How to create manual a...
------------------------------Grand Total showing in tabular Form---------------------
• How to display grand t...
// for calculating total
var qty = ($v("C_QTY") != "")?parseFloat($v("C_QTY")):0;
var price = ($v("C_PRICE") != "")?parseFloat($v("C_PRICE")):0;
var tot = 0;
if(!isNaN(qty) && !isNaN(price)){
tot = qty*price;
}
$s("C_TOTAL", tot);
// For calculating Grand Total
var model = apex.region("item_dtl").widget().interactiveGrid("getViews", "grid").model;
var qtyKey = model.getFieldKey("QTY");
var totKey = model.getFieldKey("TOTAL");
var totQty = 0;
var totAmt = 0;
model.forEach(function(r) {
var qty = parseFloat(r[qtyKey], 10);
var tot = parseFloat(r[totKey], 10);
if (!isNaN(qty)) {
totQty += qty;
}
if (!isNaN(tot)) {
totAmt += tot;
}
});
$s('P83_TOTAL_QTY',totQty);
$s('P83_GRAND_TOTAL',totAmt);

[@danieldallagnol6068]

The best.Congratulations. Simple and efficient

[@vibhordutt9461]

Hi, Your videos are really helpful, Thank you for sharing this info. can you guide me in one case? I am creating a Master detail form which has nested detail regions, I am having issue to generate the sequence for the second detail level

[@nazmulhaque4007]

Spacially Thanks for the calculation Code put in description.

[@nazmulhaque4007]

Realy Nice and Usefull Vedio, Thanks a Lot

[@SathiSobuj]

This was very helpful for me. Thank u.

[@imranhasan590]

যখন Details তে Quantity এবং Price দেই তখন Total টাকা দেখায়। কিন্তু Create করার পর যখন pencil icon তে Click করে detail check করি তখন Total টাকা আর দেখায় না,,,, এই সমাধান কিভাবে স্যার। দয়াকরে জানাবেন। 🙂

[@sameralsombaty4447]

Very good

[@sonjoydas1824]

calculating total part is not working apex 21..

[@usmanAli-hw5xu]

calculating total part is not working apex 21..

[@nam-ora-apexify]

Will work. Follow the steps carefully

[@vamsipratthi5367]

Yes, it's not working