nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a column with a specific data pattern

SpannerHead

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.

Accepted answers

jthi

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)

shampton82

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
)

All comments

jthi

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

jthi

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

SpannerHead

Jarmo

Second one exactly.

jthi

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)

shampton82

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
)