Condition

[#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

[sathishkumar_go]

Hi

Can u attach ur application?

-Sathish

[#3]

I think bracket misplaced wrongly

Try this

=If([ANO]=[ANO]-1, (SUM(Valores*Peso)/Sum(Peso)),0.00))

-Raghu

[#4]

Thank you, the formula works, but the campo YEAR is distint Year that is a variable, that is to say if I claim that selected changeable Year, actualize the formula.

Thank you.