Calculation on cumulative data

Anonymous — Tue, 30 Sep 2014 09:53:52 GMT

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 )

Thank you in advance for your lights!

topic Calculation on cumulative data in QlikView

Calculation on cumulative data