Last Modified Date: 27 Mar 2017
AnswerCreate a new calculated field to replace the original moving average calculation using the formula below:
IF ISNULL(LOOKUP(SUM([Measure]),-X)) THEN NULL ELSE WINDOW_AVG(SUM([Measure]), -X, 0) END
"X" is the number of days that the moving average is computed from. This calculation allows the moving average to only be computed if there are at least X days worth of data, and will display a NULL if there aren't enough.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials