CONDITIONAL COLUMN SUM in CHILD TABLE

[PAMPERO]

I want to sum a column in a Child Table, and put the TOTAL in a field of the master Doctype, but I want to sum not all the rows, just the rows that have in another column the same opinion that I choose in another field of the master Doctype. Can somebody help me?

[pratu16x7]

This should help, similar functionality:

Sum total of filled rows in child table

Hi! I have a Doctype call “Viaticos” with a chil table call “Rendiciones”. I have a field in the Doctype “gastos_con_tarjeta” where I want to sum the column “total_pagado” of the child table. But, I want to sum just the rows of the child table that in another column call “tipo_de_gasto” have the value “Combustible”. The Custom Script I have sum all the rows, how can I make it? frappe.ui.form.on(“Rendicion”, { entrada_de_pago:function(frm, cdt, cdn){ var d = locals[cdt][cdn]; var total = 0; …