Hi
i wrote this formula.It has taken without any errors but showing zeroes
This is my formula
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0
Can u provide correct formula
Hi @Sirisha88 ,
The formula that you have applied is correct. You will be able to see the values from the next year onwards i.e. Week 1 FY20. This is how the Offset works.
I hope it helps
~Anand
When you write -52 you are trying to get data from Volumes 52 weeks in the past.
If this is done on purpose then you have to check the time dimension of both line items.
Time ranges can be different and the system thinks that you are referring out of the time scale.
Check https://help.anaplan.com/4f5a095c-0e7a-4f1a-b6ea-0ef8f88d6c3f-OFFSET
Thank u soo much for your replies..i got it
Hello all,
can you please help me to solve this:
I write the same formula but steal have 0 in line item volumes;
If all periods exceed 100% i want it to flag red like below. How do i apply the condition at summary level?
i have three version YEP 1, YEP 2 and Budget. Only YEP 1 and YEP 2 have the option to select mapping. Budget is fixed mapping. How do i restrict the selection to only show YEP 1 and YEP 2
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
