Hi Everyone,
Could someone please explain this formula in layman's language.
OFFSET(1, -1, 0) = 0
Thanks
JH
Hi @zaibhamid81,
You can check the documentation of OFFSET(WHAT, SHIFT, DEFAULT) function with examples here: https://help.anaplan.com/4f5a095c-0e7a-4f1a-b6ea-0ef8f88d6c3f-OFFSET
Now to explain your exact use:First argument of OFFSET (which I would axplain as "WHAT", in this example it can be any number different than zero) tells Anaplan to give you value "1", but (because of second argument of function = -1, which you can imagine as "SHIFT") as if it was in previous period. So Anaplan tries it and does yield 1 for every period, but not the first one. Why not the first one? Because for the first one there is no "previous" period - so Anaplan uses third argument (which you can explain as "DEFAULT"). So OFFSET(1, -1, 0) will return 0 for first period, but 1 for every next - That's why you then compare it with "0", so you have TRUE for first period only, and FALSE for every other.FYI: almost all parts can be changed in this formula and it will behave in the same way, as long as Y is not equal to X: OFFSET(Y,-1,X)=XNow you should see that format of X and Y doesn't matter, so you can even simplify the formula to "OFFSET(FALSE, -1, TRUE)"
Thank you @M.Kierepka for explaining this formula in a very nice and understandable way.
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…