Skip to Content
0
Former Member
Jan 24, 2012 at 07:16 AM

How to Calculate Avg Stock

43 Views

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