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

# Calculation on cumulative data

Hello everyone,

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

 Mois NC Livraisons PPM NC cumul Livraisons cumul PPM cumul PPM cumul fais avec Excel janv. 1031 16141787 64 1031 16141787 64 63,87149081 févr. 1574 16222371 97 2605 32364158 97 80,49027569 mars 1202 16667917 72 3807 49032075 72 77,64305304 avr. 661 15837286 42 4468 64869361 42 68,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 )