Hi there, I’m having a small issue. I am comparing data from 2 systems, one is the CRM and the other our invoicing system. This is for reconciliation purposes. The invoicing data is broken down into revenue per month. The issue is with the CRM data, this is yearly, but has a closing date. I want to break it down into months by diving revenue/12, but spread it over the months of the year following the close date. Let me exemplify. [image]

Hello @filipisai , seems not so straightforward. Eventually decided to go with Column Expressions node (scripting but only simple if/else logic used) within 12 iteration loop. Workflow is on KNIME Hub so you can check it out: [image] Yearly Revenue Breakdown – ipazin This workflow demonstrates breaking down yearly revenue on months based on closing date. This means that monthly revenue (revenue/12) applies only for closing … Br, Ivan

Breakdown yearly revenue by date

KNIME Analytics Platform

ipazin February 18, 2021, 11:48am 6

Hello @filipisai,

glad it helped!

Maybe this topic and accompanying links help lower down the frustration

Br,
Ivan