In the sections Introduction to datasets up to and including Using the dataset II we created a model that will be used here. If you haven’t done these, it is highly recommended to do so.
Before reading this section, we suggest you take a look at getting started with formulas first.
In general, it is useful to do the guided tour before you start with the other guides.
In the sections getting started with formulas and getting started with functions the basics of this topic are presented. This section is specifically about the use of formulas and functions to edit numbers. Examples of models that show how to use these functions can be found at the example models.
If you are not at all familiar with formulas, we suggest you take a look at getting started with formulas first. In this section, we’ll cover formulas more in depth. It will therefore be useful to do the guided tour before you start.
Functions are a special type of formulas. Basically, they are pre-made formulas that do a specific thing. For example, if you want to know the age of someone, you don’t need to figure out yourself how to calculate that. You can just use our age() function!
This section will introduce you to an important aspect of the Studio: formulas. Formulas allow you to calculate things based on your user’s input. This could be a rather simple calculations, such as adding or subtracting numbers, but you can also more use complex formulas. Furthermore, the Berkeley Studio has several pre-made formulas called functions.
