Sum a column associate with children

tgattsh

I have the following layout, and I am trying to sum the "Ordered QTY" column for all children within each parent in a helper column so I can verify that amount with the parent "Ordered QTY". Any help would be appreciated and thank you very much…

Paul Newcome

You would use

=SUM(CHILDREN([Ordered QTY]@row))

Paul Newcome

You would use

=SUM(CHILDREN([Ordered QTY]@row))

sfcrews

I think you have the data you want (summed children in the Ordered Qty). You could use this formula in the new column to only show parent row data:

=IF(COUNT(CHILDREN([Primary Column]10))>0,[Ordered Qty]@row "")

tgattsh

@Paul Newcome As usual, a big thank you…

Paul Newcome

Happy to help. 👍️