Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I calculate the historical number of stocks based on what's in store today and previous inventory changes .
Is it possible?
Can you post sample input and expected output
If the variation and changes are specific or uniform ...yes you can
I know how much is in stock now , for example, 50000 pcs . Last week , it fell by 5,000 pieces and the week before that , it increased by 10,000 pcs .
If you had data as these:
week increase
3 50000
2 5000
1 -10000
you could make a table with "week" as dimension and "increase" as expression with the option "Full Accumulation".
Pay attention on the positivity/negativity of "increase".