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?