Create a column with a specific data pattern

[#1]

I want to add a column to my data that changes from "1" values to "-1" values every 101 rows.  I saw lots of ways to get close but no solution yet.  Help appreciated.

[#2]

So you wish to have repeating pattern of 1, 0.98, 0.96,... -0.96, -0.98, -1?

[#3]

Or first 100 rows of 1 and then 100 rows of -1?

[#4]

Jarmo

Second one exactly.

[#5 · Accepted solution]

You can do this with different combinations of Row(), Mod(), Floor(), Ceiling()... Here is one example which might do what you are looking for

1 - 2 * Mod(Floor((Row() -1) / 100), 2)

[#6 · Accepted solution]

Hey @SpannerHead ,

These are always fun challenges since there are so many options!

Here another way besides @jthi excellent method

If( Row() < 101,
	1,
	Lag( :Column 1, 100 ) * -1
)