Different Math Formula for Different Row in One Same Column

Hi,

I have twenty rows in one column (Column A). I would like to perform different mathematical formula for different row, Row 1- 10 ==> 2 * (Column A) , then Row 11 - 20 ==> 3 * (Column A).

Thank you for your help

Regards

1 Like

Hi @rizky_kahfie

There is an If-Condition “if (cond, trueval, falseval)” instruction in the -math Formula- node which allows to do a conditional operation:

The instruction to write in your case would be:

$Column A$ * if( $$ROWINDEX$$ < 10, 2, 3)

Hope this helps.

Regards

Ael

10 Likes

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