We would like to calculate the average inventory in the finance module, from current year to previous six years.
Suppose for example if we want to calculate average value of the one particular period Say Year 2008 means we have to add previous year's 2007 inventory with the Year 2008's inventory divided by two.
How to Calculate this scenario in query designer.
Veeru