Math Formula Output Data with RowIndex


I have faced a strange behavor on my math formula so i am writing about it:
Created a new column with $$ROWINDEX$$/5(convert to integer) to group the rows by 5 but the output is as in below. And there is same output with mod($$ROWINDEX$$, 5) . If the formula is ($$ROWINDEX$$-2)/5 it will output the expected result (0 for first 5 rows) . Any idea why this happens?
row id new row
0 0
1 0
2 0
3 1
4 1
5 1
6 1
7 1

Converting to int uses rounding (via this). It sounds like what you want is to use the floor(x) method in the Math Formula node.

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.