Sum Repeating Group Fields, Conditional on Second Field

[DanielH]

Hi,

I have a repeating group for payments towards a simple order invoice. Inside that RG I have the payment date, amount, type (card, bank account, etc.), and status.

I can sum the payment amounts just fine, but how should I sum these amounts only if the item’s “status” is ‘succeeded’ (or other text value)?

Some payment methods, such as ACH bank payments, can be ‘pending’ for 3+ days, so don’t want to show the “Remaining Balance: $0” until they have fully settled (and changed to status = ‘succeeded’).

Thanks

[publi.code]

[DanielH]

Thanks–I figured it was a simple solution! Sometimes I just get lost in all the various dropdown options when dealing with multiple complex data sources.

Very helpful to have such a quick response.