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 SUM the last three months

In the line item "last 3 months sum", I'm trying to sum the last three months.

I tried using timesum but wasn't getting the right numbers.

Any help appreciated, thanks!

Tags

Modeling

Model Builder

Accepted answers

Hi @ashasli,

Try using MOVINGSUM().

You can also watch this legendary video by Rob.
TIMESUM vs. MOVINGSUM

I hope this helps.

Seyma 🌷🙂

All comments

Hi @ashasli,

Try using MOVINGSUM().

You can also watch this legendary video by Rob.
TIMESUM vs. MOVINGSUM

I hope this helps.

Seyma 🌷🙂

Thanks @seymatas1 it worked! MOVINGSUM(last 3 months, -3, -1, SUM)

Quick Links

Can you help?

Unanswered questions

Native function for Date & TimeStamp
Hi, is there in Anaplan the possibility to retrieve current time (date and time)? I know that now this is possibile only via integrations, but I will need to know if there is a native function.
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
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…