5 Replies Latest reply: Aug 10, 2017 4:43 AM by Giovanni Chiozza RSS

    Using accumulated values in chart for calculation is not working

    Hui Ming Wang

      Hi,

       

      I have 2 accumulated values in my chart.

      When I tried to use the 2 values to calculated a 3rd value with the formula (=sum2/count1), the result is wrong.

       

       

      For example, for the last result: sum2/count1 = 53.0/39.7 should be 0.74 and not 0.6.

      QV seems to ignore the accumulated values and use back the original values.

      qv_accum.JPG

       

      Any help to calculate the correct result is greatly appreciate