kcsilentbob
Technical User
good afternoon everyone.
Running Crystal XI
I am using the weighted average feature in crystal when looking at seconds to process work. My problem is that I am getting a different value for weighted average when compared to the sumproduct feature in EXCEL (manager is trying to validate crystal info) here are the specs
Count average secs
stat a 1 8
stat b 103 324.34
stat c 5632 6890.64
Crystal shows weighted average of 9381.79
Excel using (SUMPRODUCT(C2:C4,B2:B4) / SUM(B2:B4)) shows 6771.5.
Can anyone help?
Running Crystal XI
I am using the weighted average feature in crystal when looking at seconds to process work. My problem is that I am getting a different value for weighted average when compared to the sumproduct feature in EXCEL (manager is trying to validate crystal info) here are the specs
Count average secs
stat a 1 8
stat b 103 324.34
stat c 5632 6890.64
Crystal shows weighted average of 9381.79
Excel using (SUMPRODUCT(C2:C4,B2:B4) / SUM(B2:B4)) shows 6771.5.
Can anyone help?