nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get the average of a previous month in the current month ?

tinathom

Hi

I have a grid where in I need to calculate the average of the commissions selected for a couple of months and then to send it to another grid of a different month. How do I do it ?
PFA screenshots
Need help urgently

Thank you

Image_2_145018.png

Image_1_145018.png

Accepted answers

JaredDolich

@tinathom

Yep use TIMESUM, not CUMULATE and only sum on the months you want, presumably the last three months. Use a dimensionless module to calculate the last three months so you aren't hard-coding. You've almost got this!

All comments

JaredDolich

@tinathom

MOVINGSUM would be your best choice since the TARGET module also uses time. In a clutch, you can also use TIMESUM but that is not a very efficient function. If you use MOVINGSUM you'll need to also add up the denominator so you can calculate the average. This can be done by using a counter (If commission >0 then 1 else 0). This will give you the count to use to create the average.

So, MOVINGSUM(Commission of the months you're interested in) / Counter = Average commission.

Now, if you only need one value for the current month, then I would suggest you create a reporting module that is not dimensioned with time at all. This will allow you to use TIMESUM.

tinathom

Thank you for replying
I used Timesum(Average) in a module that has no dimensions but it gave me a huge value.
PFA screenshots @JaredDolich

Formula_used_145053.png

Guarantee_1_145053.png

JaredDolich

@tinathom

Curt866

Has there been any fix created for this yet?

MYiClubOnline

tinathom

Hi @JaredDolich
Thank you for the help and the encouragement . This helped me a lot. Appreciate it.

PFA the screenshots.
This looks good now right ?

Image_of_Module_2_formula_145094.png

Image_of_Module_1_145094.png

Image_of_Module_2_145094.png

Image_of_Module_1_Formulas_used_145094.png

tinathom

Yes @Curt866 If you want , we can discuss.

jehular

Hi, Would like to ask If I want to get the average of Jan 22 and Jan 23. Is MOVINGSUM function would be the best choice to use ?

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…