Adding the values using nested if statements into one final columns

Hello everyone.

I have been struggling to write the function in column expression node using nested if statement on different columns and adding the result in new column.

Please find below the statement i am using. It runs individual nested if but does not add those all together. Please advice as what is the best node to use.

I am new to knime and am not familiar with Java and is limited to use nodes only. The data i have has roughly 1 million rows and 220 columns to extract the value and add those up:

if (column(“Test1-Mode)”)==0) {

column(“Test1-Max)”)}

else if (and (between (-1,column(“Test1+Skewness”) , 1)), column (“Test1+Kurtosis”)<3) {

column(“Test1-Mean”)}

else {column(“Test1-Median”)

}

+

if (column(“Test2-Mode)”)==0) {

column(“Test2-Max)”)}

else if (and (between (-1,column(“Test2+Skewness”) , 1)), column (“Test2+Kurtosis”)<3) {

column(“Test2-Mean”)}

else {column(“Test2-Median”)

}

+

if (column(“Test3-Mode)”)==0) {

column(“Test3-Max)”)}

else if (and (between (-1,column(“Test3+Skewness”) , 1)), column (“Test3+Kurtosis”)<3) {

column(“Test3-Mean”)}

else {column(“Test3-Median”)

}

thanking you in advance

regards