Hello friends,
I am wondering if it is possible to write a FOX formula calculating stocks using the stock of the previous period as a basis, in the incremental way. Let me share the scenario.
I have three key figures: A (production), B (sales), C (stock).
A and B are in use, C is empty so far and I would like to have a function to fill it up. I should calculate the stock like this:
C = C of previous period + A - B
The sample of data is like this:
Period / A / B / C
01.2010 / 100 / 60 /
02.2010 / 300 / 210 /
03.2010 / 200 / 100 /
Is it possible to wrote the function using FOX to address it? I guess some sorting would be necessary to be sure that I start the calculation starting from the very first period...
Thank you in advance for your hints.
Arelis.