Thank you 🙂

Hi,
Thanks for replying.
This is what I have done. I get the results I want but it seems not the correct why of doing this.

Do i need a loop?

Thanks for the help.

In the example below it returns month 6 and it says that the startmonth=5. But in fact the starting month is 3.

maxamount for year 2012 is 3533.79

insert...

Thanks for the reply.

Every time a month exceeds the max amount allowed I have to go back to the previous months and sum the months including the month that exceeds....

Awesome thanks 🙂

Hi,

Below is my revised table. Customers 1 and 2 will have 0 left but customer 3 will have 23 left has could only buy 27 units from him. The other...

Thanks 🙂

How do I calculate the AmountLeftWith field? I wrote it hardcoded now in the example but that is what the acutal result should be.

Thanks

I hope I got it right this time 🙂

Hi,

It's not 250.00 but 250.000.

Hi,

Sorry for the mess. Here is the code. The max that user can buy is 250.000 so customers 1-3 get left with 0 and customer 4 with 577 as user...