Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Can u attach ur application?
-Sathish
I think bracket misplaced wrongly
Try this
=If([ANO]=[ANO]-1, (SUM(Valores*Peso)/Sum(Peso)),0.00))
-Raghu
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.