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:
Click on the
Add Column
icon ->Add Computed Column
Rename the Field
Click on the
Set up with Formula
iconNow we should configure the Value for that Column. We will use the * operation to calculate the Total cost value:
=item.Cost * item.Amount
Now let's concatenate the Total cost with the currency $ using the CONCAT() function:
=CONCAT("$", item.Price * item.Quantity)
Last updated