Conditionally substract current from previous value – KNIME Community Hub

[mwiegand]

Corresponding Forum Post

Substract actual Value from previous Value under certain conditions

Hi Community, i have following problem: Every month i get a table with new Data and i calculate the difference to the previous moth for a list of KPIS. Is it possible to create a Workflow which says: In Periode 3 (P03) look for “BU”, “Reporting Unit Name”, “Commodity” and “Consolidation Step” Search this line in Period 2 (P02) Calculate the difference for every KPI in an seperate Column. Do the same with the Data when Periode 4/5/6… is available [Difference Period] Difference Period.xlsx …