Calculation In ERPNext

[Syed_Anas]

I want to calculate all A-grade students in one field and B-grades in another and the same for F-grades in the total failed field how can I do this?

[NCP]

Hi @Syed_Anas,

Please check the reference:

Sum fields in child table and show total in parent field

Hi @msiam, Please apply custom/client script. frappe.ui.form.on('Sales Invoice', { validate: function(frm) { ttl_itms_dicnt = 0; $.each(frm.doc.items, function(i, d) { ttl_itms_dicnt += flt(d.discount_amount); }); frm.doc.total_items_discount = ttl_itms_dicnt; } }); Please check your field name and set it according. Then reload and check it. Thank You!

Thank You!

[Syed_Anas]

frappe.ui.form.on(‘Price Amount Distribution CT’, {
calculateTotal(frm);
});
function calculateTotal(frm) {
var childTableData = frm.doc.prizes || ;
var totalSum = 0;

for (var i = 0; i < childTableData.length; i++) {
    var raw = childTableData[i];
if(raw.grade === 'A'){
	totalSum+=1;
}
}

frm.set_value('total_student', totalSum); 
refresh('total_student')

// Fixed this line

}

I have tried this but it doesn’t work is there any error?

[NCP]

Where is the validate event?

Please check the example.

Thank You!

[Syed_Anas]

Thank You