5 Replies Latest reply: Aug 4, 2016 4:35 AM by Jarrad Murray RSS

    Issue calculating standard deviation

    Jarrad Murray

      Hi All,

       

      I am having an issue with calculating a standard deviation from a record level table.

       

      I have a table with the following aggregated values 243, 309, 452, ,587, ,580, ,447, ,540, ,560, ,518, ,565, ,584, ,613, ,462, ,455. Performing a standard deviation calucation on this gives me a figure of 108.89

      Using the code '=Stdev(aggr(sum({<PODGroup4Description = {'AandE'}>}ActivityActual), MonthYear))' gives me the figure 262.76

       

      Has anyone encountered this before or does anyone have an idea as to what I am doing wrong.

       

      Any help is greatly appreciated.