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

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

Here’s how I’d approach it:


The Pivot/Unpivot operations are the key steps.

2 Likes

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