Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am trying to create an expression that will calculate the number of days in the month selected which are above a trailing 3-month average. So far this is what I've got:
=Sum(
Aggr(
If(
Sum({<PeriodNumber={$(=Max(PeriodNumber))}>} Value)
> Avg({<MonthYear=,PeriodNumber={">=$(=Max(PeriodNumber)-2) <= $(=Max(PeriodNumber))"}>} Value)
,1,0)
,Dept,Date)
)
Any ideas what I'm doing wrong? I just get Zeros.
=SUM(Aggr(IF(SUM(Value) >= Avg(TOTAL {<MonthYear=,PeriodNumber={">=$(=Max(PeriodNumber)-2) <= $(=Max(PeriodNumber))"}>} Value), 1,0),Date,Dept))
Hi Manish,
Thanks for responding!
That calculates # of days above the overall average. I would like to calculate the number of days above the three-month average for each department. Is that possible?