YTD Average

Tony20

Looking to create a YTD average on a module line item.

Could someone please help?

Thanks

Accepted answers

JaredDolich

@Tony20 !!

Great question. Lots of ways to solve this. For YTD average you may want to be a bit more creative in the solution so you have more control over the math. You can try to use the YTD built in functionality but I think you'll find that difficult to work with.

So here's one idea:

I went ahead and used a variety of summary options like average, closing balance, max so you can see how they work. This gives you much more control over the time periods and removes the need to worry about the "current period" functionality.
If you need current period, then I would suggest setting that up in a system module and referring to it in a formula vs using the built in current period functionality. But that's just my opinion.

All comments

JaredDolich

@Tony20 !!

So here's one idea:

I went ahead and used a variety of summary options like average, closing balance, max so you can see how they work. This gives you much more control over the time periods and removes the need to worry about the "current period" functionality.
If you need current period, then I would suggest setting that up in a system module and referring to it in a formula vs using the built in current period functionality. But that's just my opinion.

Tony20

Thank you very much for prompt reply. Think I have what I want now.

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…