Sum of multiple columns in Child table

AppSheet AppSheet Q&A
, ,
1

Hi, I have a Table A and child table B, Column2 is a list of data in Table B. How can I create Column3 to list the sum of columns in Table B? Thanks!

Table A
Column1
Column2
Table B row1 price1, price2, price3
Table B row2 price1, price2, price3
Column3
sum(price1), sum(price2), sum(price3)
2

If you have child records with the Ref field, you should have a virtual list column named like “Related Childs”. That’s a list of key values from related child records. If you want to sum all prices from those records, you can do that like…

SUM([Related Childs][Price])

1 Like
3

Thanks Aleksi. Yes I can do SUM SELECT. I want SUM multiple columns and the result to be like an in line view. Is it possible?

4

One way is like SUM([Related Childs][Price1])+SUM([Related Childs][Price2]). Or you can first sum prices in the child record and then calculate the total like SUM([Related Childs][TotalPrice])