Math formula for different columns

[Schmali93]

Hi together,

I have the following issue:

I have a table with four columns with double values and I want to divide each value from each column by three. Attached you can find an Excel-file with dummy-values for the better explanation.

I’ve solved it with four different Math Formula Nodes in a row. I have also tried the Math Formula Multi Column Node but I didn’t get it to work.

Is there an opportunity how to solve it without combining four Math Formula Nodes with almost the same configuration?

Thank you and regards,

Andreas

Example.xlsx (11.3 KB)

[ScottF]

Hi @Schmali93 -

How about this config for the Math Formula (Multi Column) node? The key is the use of the special Current_Column parameter.

[Schmali93]

Hi @ScottF,

that is exactly what I was looking for!

Thank you for the hint regarding the Current_Column parameter.

Best regards,

Andreas