3 Replies Latest reply: Aug 4, 2016 10:33 AM by Jarrad Murray RSS

    Standard deviation with aggregate set analysis

    Jarrad Murray

      Hi All,


      I am trying to apply set analysis to a standard deviation equation which uses an aggregate function.  I am having real difficulty getting this to work correctly and would greatly appreciate and assistance or guidance.


      The equation that I am using is


      Stdev(aggr(sum({<PODGroup4Description = {'AandE'}, MonthKey = {'<=$(vMonthPosition)'}>}ActivityActual), MonthKey, ActivityActual))


      The variable $(vMonthPosition) = 13  but will be calculated within the application to allow it to be dynamic.


      This equation gives me a figure of 262 for the standard deviation instead of the 108 I am expecting.


      Looking at the comments about the aggregate function I need to apply the set analysis within the outside of the aggregate but when I do this it errors and gives me nothing.


      Does anyone have an idea as to where I am going wrong with this or what I might be able to do to fix it.


      Kind Regards