2 Replies Latest reply: Aug 14, 2012 9:10 AM by andrepeter RSS

    Standard deviation for table.

      Hi,

      I need to calculate of standard deviation on column Type for every date. But I am not able to use stdev function. It just gives, empty boxes.

       

      TypeNumber of daysDateCount
      CC111-Aug-20121
      CC162-Aug-20121
      CC113-Aug-20121
      CC112-Aug-20121
      DD111-Aug-20121
      DD111-Aug-20121
      DD161-Aug-20121
      DD161-Aug-20121
      DD312-Aug-20121
      DD312-Aug-20121
      DD313-Aug-20121
      DD313-Aug-20121
      EE62-Aug-20121
      EE62-Aug-20121
      EE62-Aug-20121
      EE62-Aug-20121
      EE63-Aug-20121
      EE113-Aug-20121
      EE312-Aug-20121
      EE312-Aug-20121

       

       

      I tried to create table with Type, Number of Days, Date, Sum(Count), stddev(Aggr(Sum(Count),Type,Number of Days).

       

      But stddev function is showing empty values.

       

      Any advice how to make it work?

       

      Thanks in advance for your help.