Hi Experts,
User wants to see Avg stock in the report
say stock values are as following
MONTH-StockReceipts- Sales- Closingstock
1- 365- 12- 353
2 - 0- 89- 264
3- 0- 80- 184
4- 0- 110- 74
5- 0- 12- 62
6- 365- 24- 403
7- 0- 110- 293
8- 0- 12- 281
9- 0- 67- 214
10- 0- 90- 124
11- 0- 100- 24
12- 0- 24- 0
if user enters 01.01.2011 to 31.12.2011
Avg stock should be 189.6(this is the avg of closing stock)
in this example total Stock Receipts 730, Sales 730 and Clsoing stock on 31.12.2011 is 0.
in the Report along with this Avg stock there are other key figures also.
how can we calculate the avg stock value based on every month closing stock between the time interval.
say if user enter 01.01.2011 to 31.12.2011 then i ahve to consider the 12 periods closing stock
Regards,
Chandra