Subtract value based on type (Calculate Cogs based on Net sales and Gross Profit)

[fredrikt]

Hi,

Hope all is well.

This is probably an easy question for all experienced in KNIME - I’ve got a dataset where I want to calculated and include Cogs of goods sold in my Type, as of now I got Net sales and Gross Profit in the Type column so what I’m trying to figure out is how to:

Find type “Net sales” and “Gross profit” and calculate -Net sales + Gross Profit = Cost of goods sold and include this as a new value in the Value column and Cost of goods sold in the Type column.

Attached the dataset →
Data - Example.xlsx (9.5 KB)

@bruno29a @ScottF @ipazin

As I’m a newbie I would really appreciate if someone had the time to upload an example of a workflow.

Have a nice day /Fredrik

[elsamuel]

Here’s how I’d approach it:

The Pivot/Unpivot operations are the key steps.

elsamuel/Public – Cost of Goods Sold