Solved: Sum of values from child table - Page 2

Pratyay_Rakshit · 11-13-2020 09:50 PM

I want to sum values from a particular column of all child records for a parent record.

What is the easy way to do this?

There is one piece of documentation regarding this in the community but I didn’t get any of it.

Is the solution in line of something like ‘selecting’ all the ref_rows and using sum(select())?

Koichi_Tsuji

The easiest way

You should have auto generated List type virtual column in parent table, for related child records, something like [Related Childs] when you made REF connection between the table.

Then you can add new virtual column with expression

sum([Related Childs][NameOfChildRecordYouWantToSum])

View solution in original post