Absolute Average

[#1]

Hi All,

I need Help, Requirement is we looking for absolute Average. Case is that suppose a customer the product every month.for example customer sell the Product in April,June ,July and August then you want to find out the average .So logic is that for the Average is you have to consider the month may also for finding the average.

Any help would be appreciated.

Thanks in advance.

Regards

Deepak

[Gysbert_Wassenaar]

Something like this: sum(Sales)/(max(month)-min(month)). If you don't have a numeric month field you'll have to create one. If you have a salesdate then calculating it in the script is the easiest way to create it: month(salesdate) as month

[#3]

Hi Gysbert,

Thanks for Reply. but scenario is that Suppose in 2012-13, Customer is created in June ,Invoice is generated  or delivered in the Aug,Sept,Oct,Dec. I want to show the Absolute Average from June to Dec.i.e Sum(dispathchQty)/no of months(June-dec).

Please Give me sum Idea.

Regards

Deepak