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.
XL3SetProperty to navigate
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
