Create column with formula using specific rows

Hello,

Can you help me to get these formula in excel to knime?

What is the best way to do it?

The simplest approach would be to use the Math Formula node with a formula of the type:
$column_name$/COL_SUM($column_name$)*100

2 Likes

But what if is an specific range of columns?

Is it still possible?

I gave my suggestion based on what you initially showed. Now you’ve changed things. Why not share the whole picture and all your requirements in the initial post?

To solve this, I think you’re going to have to group the appropriate rows, then on each group, do the calculation I mentioned in my previous post. What logic are you using to decide which rows get included in each calculation?

2 Likes

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