Difference between revisions of "Average"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:HelpBooks]]
+
{{HelpFiles}}

 
  
====average====
+
==== average ====
  
Gets numeric values of all the parameters and returns the average value of them. The values of all parameters must be convertible to numbers.
+
Gets double values for row values of the column and calculates the average value of those values.  
  
'''Syntax'''
+
Returns empty if there is no valid rows
  
average(''exp1, exp2, exp3,'' …)
+
'''Syntax'''  
  
'''Arguments'''
+
average(''columnName'')
  
''exp''i: Is an expression of any type
+
'''Arguments'''  
  
'''Return type'''
+
''columnName'': Is the name of a column in the data table.
  
number
+
'''Return type'''
  
'''Examples'''
+
number or empty
  
number a = average(1, 2, 3, 4, 5);
+
'''Examples'''
  
//a = 3
+
//get the average score of all students
  
number a = average(1, "3");  
+
number a = average(Score) where (true);  
  
//a = 2
+
print(a);
  
'''Availability'''
+
'''Availability'''  
  
Version 4.8
+
Version 4.8 __NOTOC__ <!-- imported from file: 758.htm-->  
__NOTOC__
+
 
<!-- imported from file: 565.htm-->
+
[[Category:Functions_Used_in_where_Expressions]]

Latest revision as of 11:33, 20 December 2011



average

Gets double values for row values of the column and calculates the average value of those values.

Returns empty if there is no valid rows

Syntax

average(columnName)

Arguments

columnName: Is the name of a column in the data table.

Return type

number or empty

Examples

//get the average score of all students

number a = average(Score) where (true);

print(a);

Availability

Version 4.8