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 executions
By using or downloading the workflow, you agree to our terms and conditions.
Discussions are currently not available, please try again later.