Different Math Formula for Different Row in One Same Column

[rizky_kahfie]

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

[aworker]

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:

Math Formula

The instruction to write in your case would be:

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

Hope this helps.

Regards

Ael