How to calculate of two rows which has multiple value in two colums and display in another field which is in outside of table what is script for that

[Amol18013]

it this i have calculate tot of criteria and tot of m
arks and display into avrage_marks

[root13F]

see if these help you out. You will have to write custom script to do that:-

Child Table Calculation

Thanks @bohlian Below is my scenario. [image] Here i want to calculate sum of data field in material weight column and display this sum to total weight field. How can i do this ? Thanks

Sum fields amount From Child Table V7

I think what you will have to do is write a ‘for’ loop to do this. I’ll work on this tomorrow, because it’s something I need as well. As for the link, I was just putting it there so that anyone coming across either thread sees the link. Your value adding functions look correct. frappe.ui.form.on("Denominaciones", { "denominacion": function(frm, cdt, cdn) { var d = locals[cdt][cdn]; frappe.model.set_value(d.doctype, d.name, "valor", d.denominacion * d.cantidad); } }); …

One more tip it is highly likely somebody had the same doubt as you so always try searching before posting !

[Maheshwari_Bhavesh]

describe in details…

[Amol18013]

i have create child table average_marks in that i have add 3 columns
1 is number 2. criteria 3. marks
i have fetch this values in parent table supervisor_asse
In parent table i have calculate this tot of criteria and tot _marks
and dispaly in average_mark field in parent doctype
formula is Average mark = (total mark) / (total criteria)
please help and exlain which code in which file i have edit briefly

[schilgod]

write you logic for average calculation in parent custom script.

something like below, not tested,

function calculate_avg(){
   var child_rows = frm.doc.average_marks;
   var total_marks = 0;
   var total_criteria = 0;
   for(var i in child_rows) {
       total_marks += child_rows[i].marks;
       total_criteria += child_rows[i].criteria;
   }
   //calculate average
   var avg = total_marks / total_criteria;
   frm.doc.average_mark = avg;
   frm.refresh_field('average_mark');
}

frappe.ui.form.on("Child Doctype Name", "criteria", function(frm, cdt, cdn) {
    calculate_avg(frm);
});

frappe.ui.form.on("Child Doctype Name", "marks", function(frm, cdt, cdn) {
    calculate_avg(frm);
});

[Amol18013]

Thanks …

[Amol18013]

i have create custom report but not calculate average_
mark

i have explain my problem

[Amol18013]

@Amol18013

i

sorry custom script
not report

[kinzang]

@Amol18013, did solved your problem?. i want same to yours, can help me or have your code