Average 3 months data

Hi,

For your assistance please. I want to get the average of the past 3 months, however, the average result should be post to the remaining months. In the screenshot below, I created three lines items:

Commission % - input data

Latest 3 Months Average (Comm%) - I used this formula MOVINGSUM(Commission %, -2, 0, AVERAGE)

Previous 3 Months Average (Comm%) - please see formula in the screenshot.

How can I post the 5% (average of Jan, Feb, Mar) for the month of April to Dec onwards?

Thank you 🙂

Accepted answers

ChrisAHeathcote

@DMManalili

If you are not use Current Period then you can LOOKUP the average and post this forward.

For this you will need to create a module containing no dimensions or time. Add a time period formatted line item and use this to inform the LOOKUP.

All comments

ChrisAHeathcote

@DMManalili

I assume that there is a cut off point from which you want all future periods to be populated with the three month average. I will for this post assume that you are using current period.

If so you can use

=IF ISCURRENTPERIOD(END()) THEN MOVINGSUM(Commission %, -2, 0, AVERAGE) ELSE PREVIOUS(Previous 3 Months Average (Comm%))

However, I would recommend that you use a time system module to query the Current Period as this will be useful in other formulas.

ChrisAHeathcote

@DMManalili

If you are not use Current Period then you can LOOKUP the average and post this forward.

For this you will need to create a module containing no dimensions or time. Add a time period formatted line item and use this to inform the LOOKUP.

DMManalili

Thank you! 🙂

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…