Hi,
I have recently started my Level 2 and was wondering if someone could offer me some guidance.
I'm currently working through sprint 2 but I'm struggling with the formulas for the Baseline forecast FY21.
This is what I have so far.
Baseline Forecast - IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN OFFSET('DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year',52,0)*1.1
Would someone help me with where i'm going wrong? I've looked at Anapedia for help, but I'm still quite stuck.
Thanks in advance.
@TomQueens- Welcome to Level 2!
所以充分披露,我试图结束冲刺3 of Level 2 so please don't consider me a "Master Anaplanner".
But a couple of questions that might help you:
1. What are you seeing that makes you think that your formula is incorrect? My hunch is that you are not seeing values in FY21. If that is the case, you should look at the parameters that OFFSET utilizes, specifically the offset value itself. Read th first paragraph in Anapedia closely.
2. Why are you multiplying by 1.1? Remember, this is the baseline forecast...I don't think it should take into account any growth rate.
Hopefully this helps
David
Thank you David,
I looked over OFFSET on Anapedia and it makes a lot more sense now. I also went back and read over what is needed in the baseline forecast so I took out the multiplication
Appreciate your help!
I think the formula is incorrect at two places
1. If you are pulling the numbers forward (for example in Baselines) - You need to reverse the sign of 52 in OFFSET
2. Else statements should simply say keep it zero
Hi Misbah,
I have changed my formula to the following:
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN OFFSET('DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year',-52,0) ELSE 0
But I am now getting a time range error. Would best practice be adjusting DEM03 to match the same time ranges as DAT03?
Thanks for your help
You have put two then statements. Try removing that.
Hi@TomQueens
I hope you found the answer you were looking for and moved ahead, if not then read on.
First, let's go back to the requirement
We have 3 FYs in play here:
“问题”我们正在努力解决s to find a base forecast for the base forecast year FY20 only
Now look at the last bullet point of the instructions
It is directing you to how to get the base forecast - which is only for the base forecast year/1st forecast year/FY20
Any other values are not considered Base Forecast and the value should be 0 as instructed.
I hope that helps you and/or anyone who might be having the same question.
Hello everyone, hello support Team
I stuck with the same issue - different time ranges
Please see system msg:
Invalid formula:
'DEM03 Demand Forecast'.Baseline Forecast = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) ELSE 0
For function OFFSET, all line item arguments that vary by time must use the same Time Range as the result line item.
Result line item 'DEM03 Demand Forecast'.Baseline Forecast uses Time Range Model Calendar. But line item 'DAT03 Historic Volumes'.Volumes uses Time Range FY19-FY20.
Could you please help me?
You can use the model calendar.
Yours:
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) ELSE 0
Correct:
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Default Forecast, -52, 0)
Let's break this down: