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

XL3SetProperty to navigate
XL3SetProperty to navigate
Anaplan XL - Member Properties
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
How to calculate the weight?...
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…