Skip to Content
0
Former Member
Mar 12, 2010 at 11:06 AM

Exception Aggregation or Avg Inventory

35 Views

Hi,

While I am doing Inventory Development, got some issues in reporting. Below is my reporting info.

Chars in rowsr: CompCode, Sector(Nav attribute to plan), Calmonth.

1. We get Closing Inventory in runtime ( 0valstockval )

2. Turnover (Just a KF)

3. Avg Inventory is a moving avg of Closing Inventory

4. Ratio = Turnover / Avg Inventory.

Problem in getting Moving avg in Sector Level. If I use moving avg option in Calculation tab, It is working till the end of the report not breaking at Sector level. If I use exception aggregation, its not working and also that will calculate only Avg not a moving avg.

So how to get avg inventory and Ratio values.

If you give me solution in workbook also ..it ll be fine ..

Thanks,

_R