-
Re: Formula for First week of Timescale.
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 …5 -
Re: Convert Line Items to Time Periods
Hi, I am still sure that it can be done in nice and clean way (0 maintenance cost!), so I prepared small demo: @alexpavelI think you slightly misunderstood me: I proposed to use filter to show only 2…6 -
Re: Ways to identify duplicates for list import other than RANK or ISFIRSTOCCURRENCE?
I'd say the problem is you need to frequently import more than 50 million items to a list. Consider rethinking your processes, and if it's always necessary to import so many items — it'…1 -
Re: Extracting Model Size through API
Hi, I believe you are doing everything correctly, it's just Anaplan's API that doesn't send you required data for all models. I checked on my side, and when I use "?modelDetails=t…1 -
Re: Write Access by Column not Row
Yeah, so esiest way is to just chain IF/THEN/ELSE. But if you have more than few conditions to chain, then you might use solution I've mentioned above: 1. Make your drivers numeric (1 is TRUE, 0…1

