Profit calculation

Automation rules can perform various mathematical operations. In this article, you'll learn how to automate the profit calculation process by using the automation rules.

Configure fields in CRM elements forms

Click CRM > Settings > Form and report settings > Custom Fields.

Read more in the article - Custom fields & forms in CRM records.

Click the Add field button to create custom fields for deals.

Create two custom fields. Name them "Expenses" and "Profit". Select the Number type for both of these fields.

Add a new deal and open it. In the About deal section, click Select field > select Profit and Expenses custom fields.

Click the cogwheel button next to the Expenses field > click Edit settings.

Mark the field as "required" starting with the second stage. Save changes.

Read more in the article - Configure required fields for each stage.

Configure the automation rule

Click Automation.

Click Configure automation rules > add the Edit element automation rule to the second deal stage.

Delete the Name field > select the Profit field.

Type = to the Profit field > click the menu button next to the field > click Deals > Income. Then type - > select the Expenses field.

If you haven't made a mistake, the Profit field value will be ={{Income}}-{{Expenses}}. Save changes.

Read more in the article - CRM Automation rules.

How it works

After creating a deal, add products that the client has chosen.

When moving the deal to the second stage, you need to add the information about expenses.

The automation rule is activated, and the Profit field is completed.

You can check that the Automation rule has been activated in the Automation section:

Profit report

Go to Reports section > click Add report.

Add Expenses and Profit fields. Save changes.

That's how the report will look like:

Read more in the article - Reports wizard.
Was this information helpful?
Article feedback
Could you please tell us why:
Article feedback
Integration specialist assistance
Go to Bitrix24
Don't have an account? Create for free