Last Modified Date: 29 Nov 2019
AnswerTable Calculations always calculate based on the values of the given measure in the view. For averages and aggregated ratios, this means that the quick calculation produces a value based on averaging those averages or ratios. This is not equivalent to calculating the average or ratio over the moving period.
(x + y) / z + (a +b) / c ≠ (x + y + a + b) / (z + c)
In order to create the correct calculation, use WINDOW_SUM to calculate numerator and denominator separately. For averages the denominator is often [Number of Records].
Please see the attached workbook for a demonstration of an Average and a Ratio.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials