14 Replies Latest reply: Jun 24, 2015 10:12 AM by Stefan Wühl RSS

    StDev of sum

      I have this Variable vUB (works great) which concists of the below expression: 

       

      vUB =

       

      ({<[FLOW TYPE]= {'Actual EOD (OLD DATA)'}>}AMOUNT)
      -
      SUM({<[FLOW TYPE]= {'TCM  (OLD DATA)'}>}AMOUNT)
      -
      SUM({<[FLOW TYPE]= {'FW  (OLD DATA)'}>}AMOUNT)
      -
      SUM({<[FLOW TYPE]= {'O (Active) (OLD DATA)'}>}AMOUNT)
      -
      SUM({<[FLOW TYPE]= {'T (OLD DATA)'}>}AMOUNT)
      -
      SUM({<[FLOW TYPE]= {'S (OLD DATA)'}>}AMOUNT)
      -
      SUM({<[FLOW TYPE]= {'W → (OLD DATA)'}>}AMOUNT)
      -
      SUM({<[FLOW TYPE]= {'1W (OLD DATA)'}>}AMOUNT)

       

       

      However when i try to calculate the StDev results as per below:

       

       

      stdev(vUB)  = null

       

      stdev($(vUB)) = error

       

       

      any ideas?

       

       

      Rgds,

      Olle