sum of the average

[DanCasSan]

Hi, I have this formula, but it doesn't work when I do a year and month filter. Does anyone know how to restructure said formula or why it doesn't work?

Avg(Aggr(Sum({<[Tiempo.Año]={">=$(vMaxAño10)<=$(vMaxAñoAnterior)"},[Tiempo.Mes numérico]={"<$(vMaxMes)"}>}  [Precipitación]),[Tiempo.Año],[Descripción Puesto],[Sociedad.Sede Agrícola]))

I'm grateful for any help.

Cheers,

DC

[rubenmarin · Accepted solution]

Hi, you also need to add set analysis to the external Avg()

Avg({<[Tiempo.Año]={">=$(vMaxAño...>} Aggr(...

[vinieme12]

try to base your calculations on the Datefield instead

[Datefield]={">=$(=Date(yearstart(Max([Datefield]),-10)))<=$(=Date(yearend(Max([Datefield]),-1)))"}

What is the definition for these variables ? 

vMaxAño10

vMaxAñoAnterior

[DanCasSan]

Thanks for the help, you're a boss it worked perfectly for me. 😎

Regards,

DC