Forum Discussion
Usage average should have returned zero
Hi Folks, I am a bit puzzled why when using Average the result did not return (0) There is two examples: Example A: starts and ends with a value of 1000 and returns 0.027% Example B: ...
The changes do sum to zero and, hence, so does the average of the changes. If you express that as a percentage of the initial 1000, it still works. Where it all falls apart is when you express each change as the percentage of the prior value. There is no reason at all to expect such percentages to cancel.