Divide

Overview

The enrichment divides the value of one attribute by another and stores the result in a new attribute.

Common Uses

• Divide one attribute by another to calculate ratios
• Calculate percentages between two attributes

Settings

Start by going to the 'Log Enrichment' engine by going to any analysis and clicking 'Log Enrichment' in the top right.

Then click 'Add New' and choose the 'Divide' enrichment block.

Configuration Options

• Filters: Add any filters to limit which cases this enrichment applies to. The enrichment will only calculate values for cases selected by the filter.

• New Attribute Name: Specify the name of the new attribute that will store the division result.

• Source: Select whether to use case attributes or event attributes.

  • Case attributes are defined at the whole case level
  • Event attributes are defined for each individual event

• Numerator Column Name: Select the attribute to use as the numerator (top value in the division).

• Denominator Column Name: Select the attribute to use as the denominator (bottom value in the division).

• Mult Factor: Specify a multiplication factor to apply to the result.

  • Use 100 to convert decimal results to percentages
  • Use 1 for standard division with no multiplication
  • You may choose to multiply the division by 100 if the division represents percentages

Example 1: Calculate Payment Percentage

Scenario: We have invoices with:

• Total_Amount: The full invoice amount
• Amount_Paid: The amount paid to date

Goal: Create a Percent_Paid attribute showing the payment completion percentage.

To calculate the total percent paid on a case to date, let's select total paid amount as the numerator and total amount value as the denominator:

Click 'Create' and once you're ready click 'Calculate Enrichment' to add the new attribute to your data set.

From the overview, you should now be able to find the newly created attribute:

As seen from the distribution graph, most of our cases are fully paid:

Output

When this enrichment is executed, it creates a new numeric case or event attribute with the name you specified in "New Attribute Name".

The attribute value is calculated as:

Result = (Numerator / Denominator) x Mult Factor

For example:

• If Numerator = 50, Denominator = 100, Mult Factor = 100
• Result = (50 / 100) x 100 = 50

Null Handling: If either the numerator or denominator is null or if the denominator is zero, the result will be null to prevent errors.

Decimal Precision: The number of decimal places can be controlled through the multiplication factor or by using subsequent rounding enrichments.

See Also

Related Mathematical Enrichments:

• Multiply - Multiply attribute values together
• Subtract - Subtract one attribute from another
• Add - Add attribute values together

Related Topics:

• Calculated Attributes - Overview of attribute calculations
• Data Quality - Handling null values and data issues

---

This documentation is part of the mindzie Studio process mining platform.