Sun table child


I have parent table (Main) = customer details
and child table (Main customer) = gross weight column
I want to sum the gross weight column from the child table (Main customer) to the total weight column in the parent table (Main).

SUM([Related Main customers][gross weight])

See also:

Thank you for your reply

I used your expression but i got the total weight as zero.

Please find more information below.

1 Like

Try using a virtual column rather than a regular column.

Thank you is working now

1 Like