If you want to create a calculation that returns a numeric result, the simple calculation (called Calculation in the calculations menu) is the best choice. You can use a variety of operators and functions to write equations.
For a simple example using the calculation field, if you wanted to convert Height to centimeters from meters and then add this to the Weight, you could write the formula used here.
(Height * 100) + Weight
A common calculation used in Smartabase is an if statement, which gives you the ability to return different values based upon specific conditions that should be met. This follows the standard notation for if/else notation. For example:
if(Logical Test, Value If True, Value If False)
As an example, if you wanted to perform a weighting calculation that multiplied an athlete’s workload by 10 when the Session Type was Match but just return the unweighted Workload otherwise, you could write the following equation:
if(Session Type = “Match”, Workload * 10, Workload)
Remember that when you reference a field in a calculation, the field name is both case sensitive and space sensitive.