Performs instant calculations on your data

The `Math Column`

allows you to perform instant calculations on the data in your table. You can then bind it to a component in your app and see the output instantly.

Once you've added the `Math Column`

, you need to configure your calculation. As you start typing in the `Configuration`

field, Glide will guess which column you are referring to and add a new replacement field.

This means you don't have to use the full column name in your calculation. For example, instead of using the formula:

`(Item Price+(Item Price * Tax)) * Number of items`

you could just write: `(i+(i*t))*n`

and then use the replacement fields to tell the Math Column what `i`

`t`

and `n`

refer to.

You can reassign your replacements to different columns whenever you like:

The Math Column works with the following calculations:

ADDITION
**+**** -** SUBTRACTION

*****

MULTIPLICATION
**/**

DIVISION
**^**

EXPONENTIATION
**()**

PARENTHESISAnd the following functions `e.g. LOG() or ABS()`

LOG ABS MIN MAX FLOOR CEILING ROUND TRUNC ASIN COS ACOS ATAN MOD DAY MONTH YEAR

The Math Column only accepts the above symbols. It will throw an error if you try to use another symbol.