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



      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.



      Any help to calculate the correct result is greatly appreciate