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

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled