0 Replies Latest reply: Sep 30, 2014 5:53 AM by Emilien Petrini RSS

    Calculation on cumulative data

    Emilien Petrini

      Hello everyone,

       

      I have a little problem on a calculation that I have to carry on to accumulate data for my calculation.

       

      MoisNCLivraisonsPPMNC cumulLivraisons cumulPPM cumulPPM cumul fais avec Excel
      janv.103116141787641031161417876463,87149081
      févr.157416222371972605323641589780,49027569
      mars120216667917723807490320757277,64305304
      avr.66115837286424468648693614268,87689244

       

      In Qlikview I added two column NC Cumul =sum(NC) and Livraisons cumul (Livraisons) = sum(Livraison) and for this two expression i have checked Cumul = Cumul total

       

      When I want to calculate my last column PPM Cumul i did PPM Cumul = =([NC cumul]/[Livraisons cumul])*1000000

      This works for the first line, but the following it does not make me the calculation with the cumulative data I find with Qlikview 97 and the correct result should be 80.49 = (2605/32364158) 1000000 * (see last column calculate result with Excel )

       

      Thank you in advance for your lights!