Hello everyone, I've been spinning my wheels on this problem for waaay too long. Basically I'm trying to build a workflow which adds a column to my original data set. Let's call this column "Netting". My goal is to match each pair of debits and credits to each other so they net out to exactly zero. My problem arise when the debit and credit counts are not the same, for example in rows 1 to 3, we have 2 debits and 1 credit amount. Only 2 of those should be flagged as "Yes" in the netting column, while the extra debit should be either null or "No".
If anyone can help me with this it would be greatly appreciated. I've attached a workflow to help visualize what the current population looks like. I do have instances in my population which have 10 debits and 7 credits for example, so I only neet 7 of those debits to be flagged and all of the credits.
Thanks in advance!
