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 )
