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. Keep in mind that:
- If your calculation should result in a string of text, an option or data in duration form, then you should use those calculation types instead.
- If the data that you want to include in your calculation comes from a table in the form, you must use a table calculation.
- If you need to reference historical data, you have to use one of the historical calculations.
- If your calculation should display data outside of the form (from another event form or a profile form), you need to use one of the linked calculations.
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.