Alexis, generally speaking the answer is "yes". But we'll need to know what your calculated field is, and how it's being used. Please post a sample packaged workbook with dummy or sample data. Thanks,
Thanks a lot for your answer.
1) I have some data from which I create a calculated field in the second column, in order to see the variation period after period (Quick Table Calculation, and Percent Difference)
2) What I would like to do is to use the calculated field previously created in order to have a third column with a 4 Quarter Moving Average of my variation.
I manage to do a moving average of a non calculated field (e.g. Customers column), but do not succeed to do so with a calculated field as explained.
Alexis, all you need to do is wrap the WINDOW_AVG() calculation around the percent difference calc:
WINDOW_AVG((ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1)),-4,0)
The -4 sets how many previous rows you want to go back and average. In the attached I set it to show a blank if there weren't enough previous row.
Alexis.twbx.zip 1.1 MB