Sum of values from child table

[Pratyay_Rakshit]

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 · Accepted solution]

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

[Pratyay_Rakshit]

Okay let me see and try

[Pratyay_Rakshit]

tsuji_koichi:

sum([Related Childs][NameOfChildRecordYouWantToSum])

Thanks!

[casitasrd]

@Koichi_Tsuji thanks for this!

SUM(
     select(
       [Related column][amount], 
       [description] = cuota 30 )
    )

[Steve]

Please start a new topic for help with this.

[casitasrd]

Got it @Steve . The formula is working. I cannot delete the message.