hello friends I need your help
I have a PARENT table with a column [TOTAL PRICE] and THREE CHILD tables each CHILD table has a column called [TOTAL PRICE] I want to make the sum of the [TOTAL PRICE] columns of the 3 CHILD TABLES in the main column [TOTAL PRICE] of the FATHER TABLE, I have spent hours trying to solve without success...
Thank you in advance for your help
Hey try this one
SUM([Related ChildTable1][Total Price])
+
SUM([Related ChildTable2][Total Price])
+
SUM([Related ChildTable3][Total Price])
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |