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;
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
