Variance Calc YTD Module has the following dimensions: It does not include Versions and Time as I didn't see that in the training video. The YTD formula is working its just the Full Year formula is not.
Your source module has Time dimension whereas your target module doesn't have time dimension. Unless you have All Periods enabled in Time setting Anaplan doesn't roll up Time automatically. You will have to tell Anaplan which year to pull from the source module. Two ways to correct this
1. Create a Lookup module with no dimension and insert one line item. Format that line item as Time period. And Use LOOKUP on this line item in your formula. DO NOT use SELECT on any Particular year
2. If your Time range has just one year then you can enable All periods in your Time Range, Anaplan will automatically pull the numbers
Thank you for that solution. I was able to setup the Lookup for the year.
I wanted to follow up on the question you had related to Point 2: Your question was below:
On Point 2 - What is QTD? Let's say if you are in May month and you have 100 in each month until May should the expected value be 300 or 500 in QTD line item.
For QTD, I want to setup the variance calculation as follows: Say we are in May - I want to be able to compare (YTD Actuals for Jan through May + Forecast of June) vs. (Forecast for Jan through June). This would give me a variance analysis of Q1+Q2 in total. I hope this helps.
I am attaching two screenshots of Time Setting and Date Setting Module that I've setup and wondering what is the best way to utilize this to be able to perform the Quarter variance I analysis I would like to do.
Of course, it depends on your particular business case but usually, QTD means data in just the current quarter. So in your example, if you are in May then QTD will be just the data in April and May and the function QuarterToDate() will return that data accordingly. If you actually want to get the data from Jan to May then you can HalfyearToDate()
Finally, you can use YearToDate() to get the data from Jan to the current month for the whole 12 months.
For your requirement to be able to get the Actuals until the current date then use forecast after, you can utilize the switchover date feature and use the forecast version. That will accomplish that blended data requirement. However, that won't allow you to compare to pure Forecast (Jan to June) as you described. Usually, we use a forecast version with a switchover date for the "blended" version and a budget version for the static values that won't be replaced by actuals as the year progresses,
If you really want to use only forecast version for both (blended and forecast) then you can use formulas to obtain the switchover date - or current date - and then use an if statement to return the Actual data before that date and forecast data after.
Hope that helps, let me know if you have any questions