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

Update columns in a source
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
Is it not possible to have the same link in 2 dataspaces
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
why is the basic lookup not working?
Module 1 : UID * FCST - source Module 2: FCST - Mapping Module 3: UID * Time Range- Target formula used in module 3 module1.line item[lookup: module2.timeperiod]