可以在「值」的欄位新增「計算結果欄位」，例如
=SUM('Box Office Revenue ($)')/COUNTA('Box Office Revenue ($)')
EG. Our goal is to find out the total number of bags of avocados sold on each date at each location using this data.
Validating a data type means checking that the data matches the data type defined for the field.
Validating a data range means checking that the data falls within an acceptable range of values defined for the field.
Validating data constraints means checking that data meets certain conditions or criteria, such as the type of characters.
Validating data consistency means checking that the data makes sense in the context of other related data.
Validating data structure means checking that the data follows or conforms to a set structure, such as MP3 files or HTML code.
Code validation means checking that the application code systematically performs any of the previously mentioned validations during user data input.
Temporary table: A database table that is created and exists temporarily on a database server