Exclude Zero When Calculate Standard Deviation

  • Thread starter Thread starter Charles Deng
  • Start date Start date
C

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
 
Charles said:
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])
Click to expand...


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

=StDev(IIf([q1] = 0, Null, [q1]))
 
Hi Marsh:

This expression works well. Thanks a lot.

Charles

-----Original Message-----
Charles said:
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])
Click to expand...


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

=StDev(IIf([q1] = 0, Null, [q1]))
Click to expand...
 
Back
Top