Avg issue?

[#1]

Hi All,

I need to find last 12 months avg sales..

=Sum({<[Invoice Date]={'>=$(=MonthStart(Max([Invoice Date]), -11))<=$(=Date(Max([Invoice Date])))'}>}Sales)

For this Expression I am getting Last 12 Month Sales Value, I need to get Avg of this Sales ?

Regards,

Helen

[PrashantSangle]

Hi,

=Avg({<[Invoice Date]={'>=$(=MonthStart(Max([Invoice Date]), -11))<=$(=Date(Max([Invoice Date])))'}>}Sales)

Regards

[#3]

Hi,

Since number of months are constant to 12.

you can use the below.

Sum({<[Invoice Date]={'>=$(=MonthStart(Max([Invoice Date]), -11))<=$(=Date(Max([Invoice Date])))'}>}Sales)/12

[#4]

Hi Shruthi,

12 is Fine, but I need to get dynamically that value & didvided by sales is nothing but my avg..

regards,

Helen

[#5]

Hi,

in that case just replace Sum by Avg in your expression. It will calculate automatically

[#6]

HI Max,

I am getting Incorrect Value..Suggest me any other way..

Regards,

Helen

[#7]

Tried but it was not working ..

[mdmukramali]

Dear,

can you attach the sample file.

so that we can try to help you.

Thanks,

Mukram

[perumal_41]

Hi

Try this  one

=Sum({<[Invoice Date]={'>=$(=MonthStart(Max([Invoice Date]), -11))<=$(=Date(Max([Invoice Date])))'}>}Sales)

/Count({<[Invoice Date]={'>=$(=MonthStart(Max([Invoice Date]), -11))<=$(=Date(Max([Invoice Date])))'}>} Distinct month([Invoice Date]))

[mr_novice]

Sales average per month for the last 12 month?