You can use Canvas to write familiar spreadsheet formulas over live data.
You can add new columns to write any spreadsheet formula. Left or right click on the table header and select Add Formula Column to add a new column.
Enter the formula in the formula bar at the top of the canvas.
You can also write formulas in text fields by selecting = "tableName"