Store Stock calculations

[#1]

Hello,

I have a total number of items bought in january 2011 as 'Stock'. If I have the number of sold items each day, is it possible to calculate the remaining 'Stoc' month by month?

For example: in January 2011 I have the number in 'Stock', in February I should have 'Stock' = 'Stock'(initial) - sum(Sales) from January, in March I should have 'Stock' = 'Stock'(initial) - sum(Sales) from Jan and Feb, etc.

If I manage to do the calculation for the 'Stock' each month, can I restock from time to time, adding a number to the 'Stock' of the specific month?

Thank you in advance for your help,

Bogdan

[Anonymous]

Hi,

Based on your requirement I have tried to get a work around..

Find attached qvw.

Hope it helps.

[#3]

Hello Rathodniky,

Thank you for your response. I do not have the license on this computer, so I am forced to use the Personal Edition. Could you be able to paste it here directly?

Thanks,

Bogdan

[Anonymous]

Hi,

Load script insert this:

LOAD * Inline [

    Months, Stock, Sold

    Jan, 100, 80

    Feb, 200, 120

    Mar, 300, 240

    Apr, 400, 420

    May, 500, 490

    Jun, 600, 530

    Jul, 700, 690

    Aug, 800, 780

    Sep, 900, 950

    Oct, 1000, 1000

    Nov, 1100, 1005

    Dec, 1200, 1230

];

Use a Straight table with dimension - Months

Expression:

Label: Stock - Exp: =Stock

Label: Opening Stock - Exp: =(Above(`Remaining`)+Stock)

Label: Sold - Exp: =Sold

Label: Remaining - Exp: =`Stock`-`Sold`

Label: In Stock - Exp: =`Opening Stock`-`Sold`

Sort - Month - Load order - Original.