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

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…