Column calculation

[prasanth_nair]

how to calculate the sum of a column.
i,e,
column A 10
column A 10
total sum in a field 20.
In the ERPnext 15 version.

[NCP]

Reference:

Calculate (SUM) two fields and display the result on the third field on child table

Hi @NinYo, Please apply it. frappe.ui.form.on("Appraisal Template - Performance", { p_rating: function(frm,cdt,cdn) { var d = locals[cdt][cdn]; frappe.model.set_value(cdt, cdn, 'p_score1', (d.p_rating + d.p_weight)); } }); // Syntax frappe.ui.form.on("Child Table Name", { field_name_for_trigger_to_value_calculate: function(frm,cdt,cdn) { var d = locals[cdt][cdn]; frappe.model.set_value(cdt, cdn, 'child_table_total_value', (d.child_table_value1 + d.c…

[prasanth_nair]

the calculation of a column to a field.

[NCP]

Please check the reference and apply it according to the scenario.

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!