Consulting

[#1]

Hello, good days, it would have a consultation, I want to do a weighted average, since(as,like) the formula is done, but in all that I have to put it of form condional, in order that it me works according to one year as filter, it me does not work. Someone might help.
Thank you, a greeting Rose

num

(if ([AÑO]=[Año]-1,(SUM(Valores*Peso)/SUM(Peso))),0.00)

Thanks

[johnw]

I'm sorry if I don't understand. Maybe this?

sum(if([AÑO]=[Año]-1,Valores*Peso))

/sum(if([AÑO]=[Año]-1, Peso))

[#3]

Hello, more and less, but It has been of great help, thanks you very much.