Hi, i am wondering how i would go about calculated my expected depreciation of stock based on sales rate.
For example, if i have 20 units in stock and i expect to sell on average x amount (which changes) per month, how would i go about creating a formula which declines my stock from the current month.
I am currently in March with 20 stock.
January i expect to sell 3
February i expect to sell 5
March i expect to sell 2
therefore when placed in context of months i should see my estimated stock depreciation appear as
jan = 17, Feb = 12, March = 10… and so on for the year.
I can easily do this using 12 measures but thats ridiculous, i was wondering how you would do this using an iterating function?