Yearly Revenue Breakdown

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.

External resources

• Forum Topic