stdev in straight table

[Anonymous]

Hey all,

i'm trying to use the stdev() func on a straight table, my formula is :

stdev((sum(a)+sum(b))/sum(c))

but its not working  .....

any ideas ?

thanks

J

[#2]

Sum() will aggregate over all the possible values for the dimensions in your straight table. So for those dimensions you would be calculating a single number. Calculating the standard deviation for a sample size of 1 will not work, of course.

Stdev((a+b)/c) might work depending on your data model.

More likely you will have to use an aggregation such as

Stdev(Aggr((Sum(a)+Sum(b))/Sum(c),Dimension1,Dimension2))