Based on an earlier post, I am using the below method to calculate standard
deviation.

load in a simple SUM measure (x) - the sum of fact column (aggregated in
the cube)
load in a simple SUM measure of x squared (x2) - sum of square of fact
column (aggregated in the cube)
load in a counter called cnt - count of a fact column (aggregated in the
cube)

((x2 - ((x^2)/cnt))/cnt)^0.5

But this result is different from what I get with the excel stdev funtion.
Have I got the above formula wrong?

thanks in advance

--
Message posted via http://www.sqlmonster.com

I'm not sure what was stated earlier in whichever post you were refering to,
but is there a reason why you can't use the native STDDEV() MDX function?

"tarana halsall via SQLMonster.com" wrote: