LAE

 View Only

How to Create a process/job to loop until it finds correct summed value

  • 1.  How to Create a process/job to loop until it finds correct summed value

    Posted 10-16-2022 22:58
    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
    made up data


    ------------------------------
    andrew darnell
    Knowledge Community Shared Account
    ------------------------------