Sum of reference Table

AppSheet AppSheet Q&A
, ,
1

Hi,

I have created an appsheet to track name and amount I borrow or lend.

Table one “Cash” contains Unique ID, Date, Name (reference list), Amount (credit/debit)

Table two “Ledger” contains unique ID and Name (referenced to table “cash” - “name” column)

Now in ux tab, when I view “Ledger” table. When I select specific name it should show balance of that specific peroson. Does any one know the formula for the same?

I tried

SUM([Name].[Amount])

it gives sum of everything. I want sum of all the values related to that specific person.

Regards,

Piyush Diyora

2

Something like?

SUM(Select(TableName[Amount],[Name]="Bob"))

Simon, 1minManager.com

1 Like
3

Your formula might be right, but it shows same amount value for all the names. For example, in my app, in ledger table, opening balance should display “10000”, Sam should display “-500”, Alex should display “0”.

I have created a copy version of my app. Can you please look into the app and formula?

I have attached the link to my app

https://www.appsheet.com/Template/AppDef?appName=CashSample-1001100084&utm_source=share_app_link

Regards,

Piyush Diyora