Solved: Sum of the value from a table - Page 2

sOAP_WKC · 11-22-2021 01:05 AM

Hello the team,

I have a table “wallet” where users can create different wallet, and another table “expense” where users can add expense depending the wallet, I would like to use the fonction SUM to all expense of a wallet in table “expense” and add the number in the table wallet…
Could you help me please?

Aurelien

Hi @sOAP_WKC

Did you have a look to the documentation provided ?

This expression: REF_ROWS(“Expense”, “Category”)
goes with the column commonly named “Expenses”.

Nonetheless, I understand you might get trouble at getting it, as more often it is generated with the name “Related Expenses”, and it has been shortened into “Expenses” in the sample app…

So, the expression you are looking for should be, if you didn’t change it, and assuming you added (in the table Expenses) a column [Amount] with a type Decimal or Price:
SUM([Expenses][Amount])
Please note this expression has its place in the table “Wallet/Category”, as said previously !

View solution in original post