7 Replies Latest reply: Mar 13, 2015 8:54 AM by Felipe Goitre RSS

    Running/Cumulative Total Calculations

      Dear All

       

      I am using QV to calculate impact of the spare part and service costs compared to the production.

       

      My raw data has Product, Month, Year, Supplier, Production, Service & Spares.

       

      For each product, I want to calculate the impact of spare parts and service cost compared to the production level and how it change month by month.

      By using a Pivot Chart, I can obtain exactly what I looking for.

      PivotChart.JPG

       

      When I want to put in a line chart the column "cost / 1000", the cumulative functionality is not working anymore.

      The formula I am using for Cost / 1000 is:

      if(rangesum(above(sum(Production),0,RowNo()))=0,0,(rangesum(above(sum(Service),0,RowNo()))+rangesum(above(sum(Spare),0,RowNo())))*1000/rangesum(above(sum(Production),0,RowNo())))

       

      Please let me know if the formula used for the line chart should be different.

      What I want to obtain is:

      Thanks in advance.

       

      Felipe