Formula for SYS01 Time settings by week line item

ShreyaR

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

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.