This workflow demonstrates breaking down yearly revenue on months based on closing date. This means that monthly revenue (revenue/12) applies only for closing and later months. Prior months revenue is zero. This logic is applied within the Column Expressions node with a 12 iteration loop where one iteration corresponds to one month. Loop is closed by appending a newly Month column, new headers are written and final output is obtained by appending input data with Month columns.
Used extensions & nodes
Created with KNIME Analytics Platform version 4.3.1
Loading ad hoc jobs
By using or downloading the workflow, you agree to our terms and conditions.