Icon

Budget Monitoring Report

Budget Monitoring Report
This workflow accesses an accounting of a list of projects, on one branch itcalculates the money in budget for each year for each one of the project and on theother branch it calculates the money actually spent for each project each year.It then reports the money allocated, the money spent and the money remaining foreach project each year. Calculating money spent for each project each year Calculating money in budget for each project each year Calculating money remaining for eachproject each year Projects filemoney by project by yearrenaming"<year>+Sum(...)" intojust "used <year>"renaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneyby RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowID File Reader GroupBy Column Rename Column Rename Remaining Money Sorter Sorter Joiner Pivoting Pivoting RowID RowID Unpivoting ConstantValue Column This workflow accesses an accounting of a list of projects, on one branch itcalculates the money in budget for each year for each one of the project and on theother branch it calculates the money actually spent for each project each year.It then reports the money allocated, the money spent and the money remaining foreach project each year. Calculating money spent for each project each year Calculating money in budget for each project each year Calculating money remaining for eachproject each year Projects filemoney by project by yearrenaming"<year>+Sum(...)" intojust "used <year>"renaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneyby RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowID File Reader GroupBy Column Rename Column Rename Remaining Money Sorter Sorter Joiner Pivoting Pivoting RowID RowID Unpivoting ConstantValue Column

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2021-03-19
Last update: 2024-11-17
Created with KNIME version: v4.3.2
Tags: budgetfinancefinance data aggregation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!