Link datasets together to build online systems.
A dataset column can be calculated from other columns by selecting the “Formula” column type and entering a formula. This formula will be automatically calculated for all entries in the dataset, including future entries added to the dataset.
This dataset has 2 calculated columns showing percentage of sales target achieved and if a bonus has been awarded. Calculated columns are always shown with a grey background as the values are read-only.
Modify the dataset and add a column, selecting “Formula” as the column type. Then enter a formula. The results of the formula can be shown as Text or Number.
TIP Press Edit if the Formula Settings are not shown.
In this example, the two formulas used are
| Column | Formula |
|---|---|
| % Achieved | =round(100*col2/col3) |
| Bonus | =if(col2>col3,“Bonus”,“No bonus”) |
When a formula refers to a column, use “col” and the column ID number. In the example above the ID for Sales is 2, so in the formula we use col2.
A formula can be as simple as
Formulas can contain numbers, text, and functions including
These functions are described in Using Formulas and Functions