Calculation of Stock

[#1]

Hi all,

If I have data like the attached example, how do I create a column

with the value of Stock for each day.

For Example:

DayOrder                In                Out               Stock

01/01/2004      120      10               110

04/01/2004                50                20               140

07/01/2004                10                                   130

13/01/2004                80                30               180

20/02/2004                20                15               185

20/01/2004                16                                   201

   Thank All

[giakoum]

you can use the above function in charts or the previous function in the reload script to achieve this.

[#3]

  Hi Ioannis,

Can you send me an example or a link because

I dont know how to do a for ... next cycle or something like that?

          Thank

[er_mohit]

See the attached file

[giakoum]

see attached example

[Sokkorn]

Hi,

Create Strainght Table with

Dimension

     . DayOrder

Expression

     . In = Sum(In)

     . Out = Sum(Out)

     . Stock = RangeSum(Above(Total (Sum(In)-Sum(Out)),0,RowNo(Total)))

Regards,

Sokkorn