Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
For Average, try like this:
=SUM(IF(ATL='ATL',[Fiili Maliyet Tutarı]))/count(distinct MonthField)
Br,
KC
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))