Formula for SYS01 Time settings by week line item

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

Accepted answers

All comments

KirillKuznetsov

@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

KirillKuznetsov

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.

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…