Hi Jaap, Yes we will need to increment the month. Like for account 100, in the intial dataset, it has month 1 - 6. The month 1 balance is 870. So we spread out this balance based on index values. Please note the vector has 5 values. So we will need to spread out month1 balance over 5 months (month 1 - month 5) ( month 1 balance = 174 month 2 balance = 261 month 3 balance = 87 month 4 balance = 217.5 and month 5 balance = 130.5 ..all of this is captured in variable bal_1) now we need to do the same thing for month 2 balance which is 1740. Spread this balance over 5 months based on vector and capture in bal_2. So for month 6 balance, which is 5220, we need to spread this out again over 5 months based on index. So that will be month 6, 7, 8, 9 and 10. So, yes if needed the months has to be increased. For the prototype we can use, each month balance will be spread over 5 months (based on the vector). Hope this makes sense. Solution doesnt have to be array based. It could be using any other logic. Thank you,
... View more
