SELECT() in a formula on a Virutal column is not returning any rows

AppSheet AppSheet Q&A
,
1

My App has two tables

MemberDetails table has Site No, Name,Phone etc

Trx Register table has Site NO,Item, Payment mode, Payment Amount,Payment Status

Have added a Virtual Column - Pending Member Dues on Memberdetails table and set formula to select all the pending dues from trx register for given Site number.

SELECT(Transaction register[Item],([Site Number]=ANY(Transaction register[Site No])),true)

But the Virutal column(Pending Member Dues)

is coming blank.. ANy pointers to fix the issue?

2

I believe it should be something like this …

SUM(
  SELECT( Transaction register[Payment Amount],
    AND(
      [Site No]=[_THISROW].[Site No],
      [Payment Status]="Pending"
   )
  )
)
3 Likes
3

Thanks for your inputs, will try the solution and confirm

1 Like
4

thank you @TeeSee1 , your solution worked thanks

1 Like