Calculate profit
The furniture company needs your assistance again in adding a new column, Profit
, to their dataset. The profit for each order can be calculated by subtracting the discount value and the cost of goods sold from the sales price. Also, round off this value to two decimal places. As this column will be used for accounting, you are asked to add the prefix "$" to each profit value.
If you lost any progress, browse your Local space
, click on the data-transformation-in-knime
folder, and load the 2_3_calculate_profit
workflow.
This exercise is part of the course
Data Transformation in KNIME
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
