Average per month

[fatihtomruk]

Hi,

I am trying to add a column named average. It must be average of selected month's values. For example, if I choose 5 months, it must be 90,1 as below, bu if I choose 2 months (like Oca and Şub), it must be 138,4 for AB.

My expression formula is shown below.

Could you please help me?

Thank you.

Expression:

=SUM(IF(ATL='ATL',[Fiili Maliyet Tutarı]))/sum(TOTAL<BASKANLIK,MÜDÜRLÜK,ATÖLYE,[skill kod],Kayıt_Donemi_Text,MaliYıl>([Fiili Miktar])*-1)

[jyothish8807]

For Average, try like this:

=SUM(IF(ATL='ATL',[Fiili Maliyet Tutarı]))/count(distinct MonthField)

Br,

KC

[fatihtomruk]

by adding new straigt table and writing this formula, I managed this problem.

I have Avarage and St.Dev in this table. But I want to extract the min and max values when calculating Standard Deviation. Please help..??

Avg: =avg(aggr((SUM([Fiili Maliyet Tutarı])/sum(([Fiili Miktar])*-1)),BASKANLIK,Kayıt_Donemi_Text))

StDev: =Stdev(aggr((SUM([Fiili Maliyet Tutarı])/sum(([Fiili Miktar])*-1)),BASKANLIK,Kayıt_Donemi_Text))