Average for a Period of Time for Next Period

CommunityMember132037

Hi Team,

I am trying to calculate the "Average" for a Expense for the Period of "FY24". And I want to calculate using the Average from Q3 FY22 to Q2 FY23. On the "actual line items are the expenses for prior quarters and on "RunRate Line Item" I want to calculate the Average for those 4 prior quarters.

I am try TIME SUM and it didn't work unless I am missing something =( Would you please help me find a solution? Thanks!

Yordana!

Accepted answers

Badam

Hi Yordana,

For moving time, to get the data of the last N, no of periods we cannot use TIMESUM. We need to use MOVINGSUM for calculating the data. In your case, you can apply the following formulae in Run rate to arrive at the solution.

Run Rate: MOVINGSUM(Actual Load, -4,-1,AVG)

Kindly let us know, if it worked out for you or not.

Thanks & Regards

Badam Anjani Prasad

Matasma Digital Technologies

All comments

Badam

Hi Yordana,

Run Rate: MOVINGSUM(Actual Load, -4,-1,AVG)

Kindly let us know, if it worked out for you or not.

Thanks & Regards

Badam Anjani Prasad

Matasma Digital Technologies

CommunityMember132037

Thank you @Badam !!

Your solution work but with a slightly change on the periods MOVINGSUM(Actual Load, -6, -3, AVERAGE).

That's the formula for Q1 FY24 but then I want to make Q2 FY24 to Q4 FY24 equals to Q1 FY24 because if not the formula for the other periods will take the zeros of the FY23 quarters that had not happened yet.

So on the example below - I will need that Q2 FY24 ---> have as value $10,258.

Thanks!

Yordana T.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Python API SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
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…