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!