Hi Guys
I am hoping that someone can help me in coming up with a process/job that can loop through amounts until it matches a total I am looking for.
I have one set of data "match amount" that are totals per customer field. I have another set of data "individual amounts" that I need to loop through looking to match/add up to the "Match Amount" per customer. The data contained within "individual amounts" can contain extra values that are not needed to make up the value contained in "Match Amount".
For example, customer 1234 has 6 amounts but only requires 4 (blue cells) of these values to add up to the "match amount". The same for customer 5678 has 6 amounts but only requires 4 (orange cells) of these values to add up to the "match amount"
Below is an example of data
------------------------------
andrew darnell
Knowledge Community Shared Account
------------------------------