Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Based on your requirement I have tried to get a work around..
Find attached qvw.
Hope it helps.
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
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.