Calculating Purchase Prices

KNIME Analytics Platform
1

Hello!
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.

2

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.

3

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