Hello,
I have a problem with rangesum(above
My dataset is :
Machine | EM5 Zone brossage |
Année/Semaine | (RangeSum(Above(Sum([Temps de bon fonctionnement]), 0, RowNo()))) | (RangeSum(Above(Sum([Nb pannes]), 0, RowNo()))+1) | (RangeSum(Above(Sum([Temps de bon fonctionnement]), 0, RowNo()))) / (RangeSum(Above(Sum([Nb pannes]), 0, RowNo()))+1) |
2020/01 | 9.14 | 1 | 9.14 |
2020/02 | 10.86 | 13 | 0.835384615 |
2020/03 | 52.22 | 20 | 2.611 |
Machine | EM5 Zone sablage |
Année/Semaine | (RangeSum(Above(Sum([Temps de bon fonctionnement]), 0, RowNo()))) | (RangeSum(Above(Sum([Nb pannes]), 0, RowNo()))+1) | (RangeSum(Above(Sum([Temps de bon fonctionnement]), 0, RowNo()))) / (RangeSum(Above(Sum([Nb pannes]), 0, RowNo()))+1) |
2020/01 | 9.14 | 1 | 9.14 |
2020/02 | 14.53 | 4 | 3.6325 |
2020/03 | 58.14 | 7 | 8.305714286 |
But when I put the formula in red in a barchart, I have this values :
For the machine EM5 Zone sablage, I have 4.61 !
If I select this machine, I have the value 8.31 which is the good value (the same value than in the table) :
I haven't this problem when I select the other machine 😞
please help !