Year to go calculation

Has anyone worked out a Year to Go calculation (amount of spend that is left in the year)? I thought it was as easy as

YEARVALUE(Amount) - YEARTODATE(Amount)

But this doesn't work on a versioned line item with a switchover that happens during the year. Full year for the actuals part is different to full year from the version part.

In this case the switchover for the version is Oct 23.

Accepted answers

rob_marshall

@klameer

Try unchecking the Switch over boolean for the Amount YTD and Amount YTG as well as Full Year.

rob_marshall

@klameer

The default is what is defined as the default time scale, in this case mine is at the week level

As for your second question, the use case for "combining" both actuals and forecast in the same line is to understand what the quarterly/yearly numbers are for the forecast as well as closed months (actuals). If you don't want desire/need that, simply unclick the Switchover boolean in the blueprint area and it will just show that Version (Actual, Forecast, or Budget) without bringing in the Actual data for closed months.

All comments

rob_marshall

@klameer

Try unchecking the Switch over boolean for the Amount YTD and Amount YTG as well as Full Year.

klameer

Hi Rob,

Thanks for the response. I'm trying to understand why the default is to show year values like this as default? What is the use case to separate out actuals vs forecast as two different sections in the year rather than seamlessly have the version that is selected?

rob_marshall

@klameer

The default is what is defined as the default time scale, in this case mine is at the week level

klameer

OK thank you Rob.

Quick Links

Can you help?

Unanswered questions

Poll: Should I have a single model or two separate models?
Hi Anaplanners, I am hoping to collect some feedbacks from you on an ongoing discussion I've been having with my stakeholders. My organization currently have 1 TQP model, which is focused on keep the model small and agile, and quick enough for about 200 managers to use to plan out their territories within a 5 weeks…
Error "No current transaction manager" during data import
Hi Community, I ran into an error while manually importing a CSV file into a module in Anaplan. The error message displayed is: "No current transaction manager" Has anyone experienced this issue before? Thanks in advance for your help!
Need Help: Import Updates Only Specific Combinations Without Erasing Others
Hi Anaplan Community, I'm facing an issue while importing data (text details) into a module that has two dimensions: "Unique Line ID" and "Organization x Site". The source file is based on a numbered list. It includes text-formatted columns (line items) that contain the names of the "Unique Line ID" and "Organization x…