Stdev help.

[slondono]

Hello everybody

I have a problem when i try to calculate stdev for many people. It works for just 1 person but i dont get it for many people.

Here the problem

1. For 1 person is correct

I know that is good because excel give the same result

This is the expression:

(Calendario.AnoNomina = Year)

And this happen when i delete the IDEmployee filter

What should I do to change the expression so that it does not happen? I need de stdev for every person.

Thanks to all

[swuehl · Accepted solution]

Try adding the Cod Trabjador field to your aggr() dimensions:

Stdev( Aggr( Sum(#Valor), [Cod Trabajador], Calendario.AnoNomina))

[slondono]

Perfect. So much thanks