>>Does anyone know how an EASY way (or any way) to use the STD() function (which works with the CALCULATE command) in a view or a SQL SELECT? Is my only option to calculate the STD() for each group with a separate CALCULATE command?
>
>I guess so. :-(
That's a tough one for SQL because STD needs a mean, total number of values, and each individual value to do the calculation. So it would have to go through to get the mean first, then go back to do the actual STD, not something that one SQL loop could do...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.