Difference between revisions of "Min"

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

 
  
====min====
+
== min ==
  
Gets the minimum numeric value of a specific column.
+
Gets the minimum numeric value of a set of expressions. The values of all parameters must be convertible to numbers.  
  
'''Syntax'''
+
'''Syntax'''  
  
min(columnName)
+
min(''exp1, exp2, exp3,'' …)  
  
'''Arguments'''
+
'''Arguments'''  
  
columnName: Is the name of a column in the data table.
+
''exp''i: Is an expression of any type
  
'''Return type'''
+
'''Return type'''  
  
number
+
number  
  
'''Examples'''
+
'''Examples'''  
  
//get the minimum score
+
''number a = min(1, 2, "3", 4 + 1, 5); ''
  
number minScore = min(Score) where (true);
+
''print(a); ''
  
'''Availability'''
+
''//a = 1 ''
  
Version 4.8
+
'''Availability'''
__NOTOC__
+
 
<!-- imported from file: 761.htm-->
+
Version 4.8 __NOTOC__ <!-- imported from file: 569.htm-->  
 +
 
 +
[[Category:Math_Functions]]

Latest revision as of 08:19, 17 February 2012


min

Gets the minimum numeric value of a set of expressions. The values of all parameters must be convertible to numbers.

Syntax

min(exp1, exp2, exp3, …)

Arguments

expi: Is an expression of any type

Return type

number

Examples

number a = min(1, 2, "3", 4 + 1, 5);

print(a);

//a = 1

Availability

Version 4.8