Sum Select Bug

[fahmifachrizal]

Hi, I'm new user using Appsheet,  I want to create personal expense and budgeting monitor, i'm using this formula to calculate spending from ledger table to account_balances table for each account,

ledger[ACCOUNT] equal to 'Cash' -> account_balances[ACCOUNT]='Cash'
ledger[ACCOUNT] other than 'Cash' (digital transaction)-> account_balances[ACCOUNT]='Debit'

IFS(

[_thisrow].[ACCOUNT]='Debit', 
sum(select(ledger[AMOUNT], and([TYPE]='Expense', [ACCOUNT]<>'Cash') ,TRUE)),

[_thisrow].[ACCOUNT]='Cash', 
sum(select(ledger[AMOUNT], and([TYPE]='Expense', [ACCOUNT]='Cash') ,TRUE))

)

account_balances[ACCOUNT]='Debit' return with correct total amount of spending not using cash, while account_balances[ACCOUNT]='Cash' return with incorrect amount, then i copy the data and triple checked the Appsheet database table, Google Sheet, and Excel using filter and sums it manually, the amount still different with above formula (all three consistent and correct) 

Is this a bug? or is there any other way to get the correct result?

[SkrOYC · Accepted solution]

I don't think you really wanted to remove duplicates, did you?

[fahmifachrizal]

Thank you, I thought Boolean at the end indicate which True/False i wanted based on select-row