Hello community, In my data set I get new YTD values every month but no monthly values for the individual month. My wish is to subtract the YTD value of the current month from the YTD value of the previous month. But only for KPIs which include “YTD” in their Name under the column KPI. Example: P09 YTD - P08 YTD = MTD in P09 P08 YTD - P07 YTD = MTD in P08 P07 YTD - P06 YTD = MTD in P07 etc. The search criteria shoud be: Fiscal Year / Period Month / RowIDs / BU / Consolidation / Reporting Unit Name / Commodity / BU specific / KPI I made an example in the attached file. This should be provided with the KPI 3 = MTD. How can I do something like this? Thanks for your help Daten Substraction.xlsx (2.4 MB)

Sorry, its similar to a topic i have already posted [image] how do I use a loop to adjust my KPIs KNIME Analytics Platform I would like to implement the following in my data set: every month i get a new file with the following columns Fiscal Year - Month - DATE_KNIME - Commodity - BU specific - Reporting Unit Name - KPI - KPI_2 - KPI_3 - Values - RowIDs - BU Now three conditions should be met every time I get data for another month 1.) KPI “CNI_Plan”: for each new month, the lines from the previous month (Fiscal Year - Month - DATE_KNIME - Commodity - BU specific - Reporting Unit Name - KPI - KPI_2 - KPI_3 - …

Subtract the current values of the month from the previous month

KNIME Analytics Platform

ARock1980 January 30, 2023, 6:00pm 2

Sorry, its similar to a topic i have already posted