Hi,
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