Subtract the current values of the month from the previous month

[ARock1980]

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:

1. P09 YTD - P08 YTD = MTD in P09
2. P08 YTD - P07 YTD = MTD in P08
3. 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)

[ARock1980]

Sorry, its similar to a topic i have already posted

how do I use a loop to adjust my KPIs

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 - …

[ScottF]

Thanks for providing context to your other thread. I will go ahead and close this one.