Good day
I have a Gallery and need to SUM the invoice amount of all the PAID items. My formula for the "Total Paid Invoices" textbox is as follows:
Text(Sum(Gallery1.AllItems,AmountTxtSearch),"###,###.00") && (StatusTxtSearch.Text="Paid")
PowerApps is not showing an error on the formula, however the result is "false". The formula works fine before the "&&" statement, but I need to include it as I only want to SUM "Paid" invoices.

Your kind assistance would be appreciated.