Sun table child

[Mouldi_Zeghouan]

Hi,

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).

[Steve]

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

See also:

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

help.appsheet.com

SUM()

Arithmetic sum of list items

[Mouldi_Zeghouan]

Thank you for your reply

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

Please find more information below.

[Steve]

Try using a virtual column rather than a regular column.

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

[Mouldi_Zeghouan]

Thank you is working now