Math Formula with condition or column expression

[mh_elhassan]

Hello Community,
how we can use either of Math formula or column expression to do the following

if Var1 > 0 and Var2 >0 and Var3 = 0 then (Var1 +Var 2)/(T1+T2)
else if
Var1 > 0 and Var2 =0 and Var3 > 0 then (Var1 +Var 3)/(T1+T3)

[aworker]

Hello @mh_elhassan

The following workflow shows how to implement an “if-then-else” condition using the -Math Formula- node:

Different Math Formula for Different Row in One Same Column

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: [image] The instruction to write in your case would be: $Column A$ * if( $$ROWINDEX$$ < 10, 2, 3) Hope this helps. Regards Ael

The “if-then-else” conditions can be nested in the -Math Formula- node as required in your example.

Hope this helps.

Best
Ael

[mh_elhassan]

Hey @aworker thanks for your reply
Should then put all columns before the if .
in my question above each var and t represents a column so i need to check if in each column the value is above 0 then sum and divide accordingly

[ipazin]

Hello @mh_elhassan,

although you can do if else logic with Math Formula node I suggest to use Column Expressions node. Take a look here:

COLUMN EXPRESSION: IF ... else

Hello…I am new to KNIME, not new to IT. Can you please help with syntax on this pseudocode IF col1 = ‘ABC’, then col2 * 10 else min(col4, col5)*col2 * 10/2 end I am completely confused with various {[(, to be manipulated there… Thanks!

Br,
Ivan

[mh_elhassan]

Thanks a lot @ipazin
it takes a little bit to get used to it, but it is finally working. the syntax is different from the usual
again thanks