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:
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".
Retrieving data ...