This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
hi @binuacs Really appreciate your help on this. I believe you might have uploaded the incorrect workflow since this is what I'm currently seeing and when I run it I end up with different results than your screenshot.