Most of the time all entrepreneurs take all sorts of calculations. It can be commissions for yourself and your colleagues and other calculations regarding customers, for example, the amount of the transaction, taking into account the discount and the price for all the products requested.

In this article, we will tell you how to free yourself from this routine and rely on automation.

Let's take these two cases above.

**COMMISSION CALCULATION**

Imagine you are a Real Estate agent. You have a deal and all the related information.

When you fill out all the information you have in respective fields, the "**Commission $**" field will automatically calculate your commission for a closed deal.

To set up such automation - go to your "**Settings**" -> "**Folder and field management**" tab (switch to **Fields**).

Add next fields:

**Total Price** (*field* *name can be changed*) with "**Number"** type and **Commission** (*name can be changed as well*) with "**Percentage"** type.

After that, add field **Formula** with "**Numeric" **type and put there the following:

= field("Total Price $") * field("Commission %")

As you can see, a **Formula **field takes values from the given fields and converts them in accordance with the given rule.

**NOTE:** Formula field requires **exact names** of the given fields. Otherwise, you will receive an error.

**DISCOUNT CALCULATION**

Now imagine you sell craft mugs. Recently you have sent a promo which states everyone who orders 10 or more of your mugs receives a 20% discount on a bill.

**Total price **field calculates the sum of the **Quantity **and **Price per unit **fields and **Total Price (with 20% discount) **also adds a 20% discount to it.

Iterate first step of the previous example - go to your "**Settings**" and find corresponding folder to add following fields:

**Quantity **with "**Number**" type and **Price per unit **with "**Currency**" field type.

After that, add 2 **Formula **fields with "**Numeric" **type and put there next:

=field("Price per unit") * field("Quantity")

and

=(field("Price per unit") * field("Quantity")) * 0.8

**NOTE:** Formula field requires **exact names** of the given fields. Otherwise, you will receive an error.

That's it! You've successfully set up the formulas to calculate your values automatically. That way you can save lots of time for yourself and other people.

**Haven’t found the answers you’re looking for? Ask our ****User Community on Facebook****!**