3.3.5.2 - NOT First Week of Timescale

Erpacca

Good evening,

 

I am asking for a hint, according to the formula for the item NOT First Week of Timescale ?.

 

I saw here prompted that the solution lies in the OFFFSET formula, but I have something that is not correct.

I decided by forming 3 items, but I'm not sure if this is correct.

 

Now everything looks something like this (in the picture)

 

Best regard,

non_first_week_109960.PNG

ChrisAHeathcote

@Erpacca 

Try using PREVIOUS.

When a function tries to return a value of the previous cell at the start of a timeframe it generates a zero result only for this first period if all other time periods carry a value.