16 Replies Latest reply: Mar 29, 2017 3:20 AM by Reinhold Graf RSS

    Standard Deviation in a chart

    Reinhold Graf

      Hi.

       

      I need to calculate average and standard-deviation of stock-movements.

       

      Average is calulated as following and working:

       

      AVG(TOTAL Aggr(Sum([LV_M-Abgang-Gesamt]),[LV_JahrMonat/YearMonth]))

       

       

      Standard-Deviation - actually no conclue. Tried a few approaches, but not working.

      Target must be the standard-deviation related only(!) to the selected period.

       

      Any idea ?

       

      Regards,

      Reinhold