Math Column
Perform instant calculations using the data in your project
Last updated
Perform instant calculations using the data in your project
Last updated
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 icon
Now 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)