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!
Tagged:
0
Best Answer
-
Hi @ashasli,
Try using MOVINGSUM().
You can also watch this legendary video by Rob.
TIMESUM vs. MOVINGSUMI hope this helps.
Seyma 🌷🙂
2
Answers
-
Thanks @seymatas1 it worked! MOVINGSUM(last 3 months, -3, -1, SUM)
0