Multiplication and sum of columns in child table

1

how to do multiplication of quantity and rate column. and sum of amount and shipping cost column.

Capture_po1
Capture_po11250×162 10.4 KB

2

@sapnapokhriyal288 check this Sum fields amount From Child Table V7
Calculate (SUM) two fields and display the result on the third field on child table

3

and what about multiplication of 2 fields

4

frappe.ui.form.on(‘Supplier Quotation Item’, {
qty: function(frm, cdt, cdn) {
calculate_amount(frm, cdt, cdn);
},
rate: function(frm, cdt, cdn) {
calculate_amount(frm, cdt, cdn);
}
});

function calculate_amount(frm, cdt, cdn) {
let row = locals[cdt][cdn];
row.custom_sipping_cost = row.qty * row.rate + raw.amount;
frm.refresh_field(‘items’);
}

Try This if not done please check with on load event

5

Okay I will try this