This workflow calculates the Revenue Growth KPI, according to the following steps:
- Read journal entries from ERP (debit & credit)
- Get exchange rates from service via REST API by date
- Join the two data tables
- Set debit and credit to 0 if missing
- Multiply amount in original currency by exchange rate of the date
- Calculate monthly sum(credit) as sum(revenues) for 2022
- Calculate Growth Rate KPI
- Visualize Sum(revenues) and Growth rate by period
Here the journal entry data come from an Excel file, but could be imported from SAP, Salesforce, Odoo, or a database. It is enough to change the Excel Reader node into the appropriate node for the data source.
Read more on the topic Revenue Growth on the KNIME Blog: https://www.knime.com/blog/calculate-revenue-growth-kpi
- Read journal entries from ERP (debit & credit)
- Get exchange rates from service via REST API by date
- Join the two data tables
- Set debit and credit to 0 if missing
- Multiply amount in original currency by exchange rate of the date
- Calculate monthly sum(credit) as sum(revenues) for 2022
- Calculate Growth Rate KPI
- Visualize Sum(revenues) and Growth rate by period
Here the journal entry data come from an Excel file, but could be imported from SAP, Salesforce, Odoo, or a database. It is enough to change the Excel Reader node into the appropriate node for the data source.
Read more on the topic Revenue Growth on the KNIME Blog: https://www.knime.com/blog/calculate-revenue-growth-kpi