Icon

Calculate Net Profit

Calculate Net Profit Example

This workflow shows an example of the verified component "Measure Fractional Years". It calculates the fraction of the year represented by the whole numbers between two dates. It also shows how to use the "Invert Category Sign" component

The workflow makes use of a simple example data of an ecommerce card transactions data to compute the value of transactions per completion speed and the profit versus loss total between delivered and canceled transaction

Calculate Net Profit Example


This workflow shows an example of how the following two verified components:

  • Measure Fractional Years: Calculates the fraction of the year represented by the whole numbers between two dates.

  • Invert Category Sign: Inverts the signs of the values attached to given categories.

The workflow makes use of a simple example data of ecommerce card transactions data to compute the value of transactions per completion speed and the profit vs. loss between delivered and canceled transaction.

Calculate the difference in fraction of years between the date the transaction was approved and the date the transaction was completed.

Data access:

Read the general transaction data and the completed-transaction data and join them

Count how many transactions were approved

Calculate the net profit on completed transactions versus the loss of canceled transactions

30/360 basis
Measure Fractional Years
transactions value total by approval speed
GroupBy
transaction general information
Excel Reader
completed transactions
Excel Reader
join tables
Joiner
Total net profit value
GroupBy
binning the different fractions of the year
Numeric Binner
keep only completedand canceled transactions
Nominal Value Row Filter
remove transactionsthat are still processing
Nominal Value Row Filter
give canceledtransaction negative value
Invert Category Sign

Nodes

Extensions

Links