Exclude Zero When Calculate Standard Deviation

[Charles Deng]

Hi All:

Is there anyone who could tell me how I can exclude ZERO
when I calculate standard deviation? I need to calculate
standard deviation after the data grouped, that is the
standard deviation is within the group (not aggregate). So
I use the following expression

=StDev([q1])

Thanks.


Charles

 

[Marshall Barton]

Is there anyone who could tell me how I can exclude ZERO
when I calculate standard deviation? I need to calculate
standard deviation after the data grouped, that is the
standard deviation is within the group (not aggregate). So
I use the following expression

=StDev([q1])

The aggregate function ignore Null values. To ignore zero
values, use this kind of expression:

=StDev(IIf([q1] = 0, Null, [q1]))

 

[Guest]

Hi Marsh:

This expression works well. Thanks a lot.

Charles

-----Original Message-----

Is there anyone who could tell me how I can exclude ZERO
when I calculate standard deviation? I need to calculate
standard deviation after the data grouped, that is the
standard deviation is within the group (not aggregate). So
I use the following expression

=StDev([q1])

The aggregate function ignore Null values. To ignore zero
values, use this kind of expression:

=StDev(IIf([q1] = 0, Null, [q1]))