I have a table with the following columns.
Account Number - 1 per person
Charge Number - 1 account can have one/many charge numbers
Amount - Dollar amount associated with each charge number. It can be negative or positive.
I want to have only those account numbers where the sum(Amount) < 0 and also I want to create a separate column as account balance to show that sum(Amount) for each account.
I have used the below-mentioned script but it is not giving the desired result.
=if(aggr(sum([Due]),[Account No])<0.00, [Account No])