Skip to Content
0
Former Member
Mar 05, 2009 at 03:01 PM

How to caluculate Average values in the Report

244 Views

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