Icon

Profit-Loss Comparison Across Systems for Variance Recognition (simplified)

Profit-Loss Comparison Across Systems for Variance Recognition (simplified)
Read Data Files fromDifferent systems Calculate Variances Outputs Result Table with Color Scheme Outputs Result Table with Color Scheme General Data Manipulation Profit-Loss Comparison Across Systems for Variance Recognition (simplified)This workflow compares Profit-Loss information from two systems and outputs differences found between the systems. The parameters that can be compared are Net Sales, Cost and Gross Profit.The goal is to be able to spot errors in manually inputed data in a given system, and to alert people responsible for each document where a discrepancy was found. examplehow tocreatebusiness rules andcategorize profitor costcreate pivotcreate net salesgive understandable namesadd 0s when missing valuesdifference in costdifference in profitdifference in net salesremove all rowswithout anyvarianceloop througheach responsible personand send an emailcreate a HTML table to send via emailADD your email credentials hereCreate TableAdd formattingexamplecomponentwhere you couldhandle differentguidelinesSystem 2(cost center information)System 1(Market information) Rule Engine Pivoting Column Aggregator Column Rename Missing Value Math Formula Math Formula Math Formula Rule-basedRow Filter Group Loop Start Table toHTML String Send Email Excel Writer (XLS)(deprecated) Format DocumentOwners Emails Cost Center -Guideline Handling Joiner Excel Reader Excel Reader Variable Loop End Read Data Files fromDifferent systems Calculate Variances Outputs Result Table with Color Scheme Outputs Result Table with Color Scheme General Data Manipulation Profit-Loss Comparison Across Systems for Variance Recognition (simplified)This workflow compares Profit-Loss information from two systems and outputs differences found between the systems. The parameters that can be compared are Net Sales, Cost and Gross Profit.The goal is to be able to spot errors in manually inputed data in a given system, and to alert people responsible for each document where a discrepancy was found. examplehow tocreatebusiness rules andcategorize profitor costcreate pivotcreate net salesgive understandable namesadd 0s when missing valuesdifference in costdifference in profitdifference in net salesremove all rowswithout anyvarianceloop througheach responsible personand send an emailcreate a HTML table to send via emailADD your email credentials hereCreate TableAdd formattingexamplecomponentwhere you couldhandle differentguidelinesSystem 2(cost center information)System 1(Market information) Rule Engine Pivoting Column Aggregator Column Rename Missing Value Math Formula Math Formula Math Formula Rule-basedRow Filter Group Loop Start Table toHTML String Send Email Excel Writer (XLS)(deprecated) Format DocumentOwners Emails Cost Center -Guideline Handling Joiner Excel Reader Excel Reader Variable Loop End

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: Ana Vedoveli
Created at: 2020-09-17
On NodePit since: 2021-09-28
Last update: 2024-04-18
Created with KNIME version: v4.4.2
Tags: bankingfinancial servicesreconciliationFinancial services and banking

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

Try NodePit Runner!