Hi,I am not getting formula for line item 'NOT First Week of Timescale?' in SYS01 Time settings by week module. Can anyone help.Regards,Shreya Rewadkar
@ShreyaR
There was a similar question on the community already.
Credits to @Misbah
Simplest and easiest way to find out the First period of the Timescale is
OFFSET(1,-1,0) = 0
So you would need the opposite of this: OFFSET(1,-1,0) <> 0
Cheers,
Kirill
I would even add that the formula LAG(1,1,0) <> 0 will look shorter but will do the same. And performance is nearly equal.
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…
