Calculating Purchase Prices

I am a KNIME beginner.
I am looking for a possibility to calculate sales prices.
I have an Excel file with current sales prices, manufacturing costs and the profit. Based on the manufacturing costs, the profit is calculated automatically.
I would like KNIME to change the sales price in every row so that the related profit is a certain value in every row which I can set in advance. It shall be the same value in every row.

So briefly spoken: Please change A, so that B is always the value I give you.

Is there a node that offers this function?

Thank you.

You should be able to replace values with the Joiner or Value Lookup nodes.

If it is more of a formula calculation that you are after the look at the Math and Column Expressions nodes.

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