Hello,
I have a PowerApp that I've created to help manage collections data across multiple properties and customers. Some customers appear in this list up to 50 separate times. I've figured out how to create a collection and use a formula that counts the number of rows for each customer and displays that information from within the PowerApp. I would like to add onto this by using a row in the data called "BALANCE AMOUNT" to calculate the sum of each customers outstanding balances. The formula I'm using for the collection currently is below. Thank you for any and all help!
ClearCollect(
Collection_2,
ShowColumns(
AddColumns(
GroupBy(
'New Collections DB',
"CUSTOMER_x0020_NAME",
"# of Invoices"
),
"Count of Invoices",
CountRows('# of Invoices')
),
"CUSTOMER_x0020_NAME",
"Count of Invoices"
)
);
Solved! Go to Solution.
Figured out how to do this when I stumbled across this post.
https://powerusers.microsoft.com/t5/Using-PowerApps/GroupBy-and-Sum/td-p/68831
Thanks!
Carl
Figured out how to do this when I stumbled across this post.
https://powerusers.microsoft.com/t5/Using-PowerApps/GroupBy-and-Sum/td-p/68831
Thanks!
Carl