Year To Date (YTD) summary column not showing data

Hi Experts,

I created one module, in which I added Time Range i.e FY 18, Number of Periods = 1, and Aggregation as Year To Date. For testing purpose, I added some data in some periods. I can see total amount under FY18 (Summary column), but no data appearing under YTD column.

Please let me know, if I have missed anything.

Thanks,

Varun

Accepted answers

All comments

Rashmih

HI@varun.joshi07 ,

Please enable the current period in the Time Settings. YTD will be sum to entries till the current period.

Best regards,

Rashmi

varun.joshi07

@Rashmih Thanks for reply. Yes, I do have current period enabled, but YTD value is displaying.

varun.joshi07

@Rashmih I got the resolution. I was doing mistake. The issue was that I was using Time Range FY 18 YTD, whereas Current Period in model calendar is set to FY20.

When I created Time Range FY 20 YTD, which was aligned to Model Calendar setting, where Current Period is set to Jan 20. It worked.

Thanks Rashmi for giving idea, which in turn, helped me find the solution.

Thanks,

Varun

varun.joshi07

I have another query related to YTD calculation. If YTD is calculated based on current period set under model calendar, then what would I need to do when business wants to see YTD calculation from Jan to Dec.

For instance, I have set current period as Jan 20, If user enters $10 in Jan 20, the YTD value should be $10.

If user enters $15 in Feb 20, then YTD value should show $25.

If user enters $10 in Mar 20, then YTD value should show $35.

Above example user case, I am not able configure.

Need expert advice for this user case.

Thanks,

Varun

Akhtar.shahbaz

Hi @varun.joshi07

if you use Anaplan YTD then YTD amount will show at the end of the current year only but you can calculate YTD amount by adding one more line item & using CUMULATE formula

Hope this helps!

Thanks

Akhtar

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…