Math Column

Perform instant calculations using the data in your project

Let's suppose you need to calculate the total cost by multiplying the Price and Quantity fields:

1. Click on the Add Column icon -> Add Computed Column

2. Rename the Field

3. Click on the Set up with Formula icon

4. Now we should configure the Value for that Column. We will use the * operation to calculate the Total cost value: =item.Cost * item.Amount

5. Now let's concatenate the Total cost with the currency $ using the CONCAT() function: =CONCAT("$", item.Price * item.Quantity)