Calculation
A Calculation Field is a field that allows admins to create custom calculations using SQL. It can be a very powerful tool for data analysis and manipulation.
The calculation can be used to
- Aggregate data from other fields in the same table or from related tables
- Calculate discounts or commissions
- Generate unique IDs
- Format data
Help documentation for calculation fields is available by clicking the help link under the formula field.
Here are some resources you can refer to when creating formulas.
- https://dev.mysql.com/doc/refman/8.0/en/functions.html
- https://www.w3schools.com/sql/sql_ref_mysql.asp
The field has standard property settings. You can also set the number of decimals to display if the result is a number.
Need help with the mySQL calculation required?
Click the AI link to open the builder. Tell the bot what you want to build and click OK to see update the code. Please note that the bots may not always get it right and you should check the results.
