Skip to Content
0
Former Member
Feb 21, 2011 at 09:14 AM

FOX Formula to calculate stocks

42 Views

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.