# Problen with stddev aggregation function

**URL:** <https://forum.cloverdx.com/t/problen-with-stddev-aggregation-function/775>\
**Category:** CloverDX Platform\
**Created:** [November 7, 2010, 12:00am UTC](https://forum.cloverdx.com/t/problen-with-stddev-aggregation-function/775 "2010-11-07T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![asaf](https://avatars.discourse-cdn.com/v4/letter/a/9dc877/32.png) [@asaf](https://forum.cloverdx.com/u/asaf)\
**Post date:** [November 7, 2010, 12:00am UTC](https://forum.cloverdx.com/t/problen-with-stddev-aggregation-function/775/1 "2010-11-07T00:00:00Z")

</div>

Hi,

There is a problem with the stddev aggregation function.  
When it calculates stddev aggregation for multiple records it works fine,  
but when there is only one record in the group in returns null instead of zero.

Can you please check it? it looks like a bug.

Best regards,  
Asaf

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [November 8, 2010, 7:49am UTC](https://forum.cloverdx.com/t/problen-with-stddev-aggregation-function/775/2 "2010-11-08T07:49:58Z")

</div>

Hello Asaf,  
you are right, but this bug ([http://bug.cloveretl.org/view.php?id=4323](http://bug.cloveretl.org/view.php?id=4323)) has been already fix and the function returns proper value since the release that will be released this week (3.0.1).

---

<div class="post-metadata">

**Author:** ![asaf](https://avatars.discourse-cdn.com/v4/letter/a/9dc877/32.png) [@asaf](https://forum.cloverdx.com/u/asaf)\
**Post date:** [November 8, 2010, 8:21am UTC](https://forum.cloverdx.com/t/problen-with-stddev-aggregation-function/775/3 "2010-11-08T08:21:56Z")

</div>

Thanks a lot!  
I appreciate your prompt response.