Manuals/calci/DMAX - Revision history

Devika at 19:47, 24 August 2018

2018-08-24T19:47:45Z

Devika at 22:35, 3 August 2018

2018-08-03T22:35:05Z

Devika at 22:34, 3 August 2018

2018-08-03T22:34:07Z

Jayaram at 11:24, 14 March 2017

2017-03-14T11:24:57Z

Swapna: /* Examples */

2015-10-08T19:28:43Z

Examples

Swapna at 20:29, 17 April 2015

2015-04-17T20:29:09Z

Swapna: /* Examples */

2013-11-24T21:05:13Z

Examples

Swapna: /* Examples */

2013-11-22T12:33:40Z

Examples

Swapna at 12:33, 22 November 2013

2013-11-22T12:33:07Z

Swapna: /* Examples */

2013-11-22T12:29:21Z

Examples

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''DMAX (Array,Field,Criteria)'''</div><br/>
 *Where 'Array' is the range of cells that makes up the list or database
 *'Field' shows which column is used in the function and
 *'Criteria' is the range of cells that contains the specified condition.
 **DMAX(),returns the maximum value from selected database entries.

@@ Line 7: / Line 7: @@
 *'Criteria' is the range of cells that contains the specified condition.
-DMAX(),returns the maximum value from selected database entries.
+**DMAX(),returns the maximum value from selected database entries.
 == Description ==

@@ Line 1: / Line 1: @@
-= DMAX(database, field, criteria)=
+<div style="font-size:30px">'''DMAX (Array,Field,Criteria)'''</div><br/>
-*Where 'database' is the range of cells that makes up the list or database
+*Where 'Array' is the range of cells that makes up the list or database
-*'field' shows which column is used in the function and
+*'Field' shows which column is used in the function and
-*'criteria' is the range of cells that contains the specified condition.
+*'Criteria' is the range of cells that contains the specified condition.
-DMAX()displays the largest number in a column of a list or database that matches the specified criteria.
+DMAX(),returns the maximum value from selected database entries.
 == Description ==
-DMAX(database, field, criteria)
+DMAX (Array,Field,Criteria)
-This function returns the largest number from the database that satisfies the given condition.
+*This function returns the largest number from the database that satisfies the given condition.
-*A 'field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
+*A 'Field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
 *Criteria can be any range on the Calci with minimum of one column and at least one row indicating the condition.
 *The Criteria columns should not overlap the list of data.

← Older revision		Revision as of 11:24, 14 March 2017
Line 116:		Line 116:
	*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]		*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]
	*[http://en.wikipedia.org/wiki/Aggregate_function DMAX]		*[http://en.wikipedia.org/wiki/Aggregate_function DMAX]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 28: / Line 28: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class="sshl_f" | '''Name'''
 | class="sshl_f" | '''Age'''
 | class="sshl_f" | '''Salary'''
 | class="sshl_f" | '''Age'''
-|- class="odd"
+|- class="even"
 | class="sshl_f" |
 | class="sshl_f" | &lt;40
 | class="sshl_f" | &gt;5000
 | class="sshl_f" | &gt;32
-|- class="even"
+|- class="odd"
 | class="sshl_f" |
 | class="sshl_f" | &gt;30
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | '''Name'''
 | class="sshl_f" | '''Age'''
 | class="sshl_f" | '''Salary'''
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | John
 | class="sshl_f" | 34
 | class="sshl_f" | 5500
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Bill
 | class="sshl_f" | 35
 | class="sshl_f" | 6500
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Clark
 | class="sshl_f" | 29
 | class="sshl_f" | 7000
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Bob
 | class="sshl_f" | 45
 | class="sshl_f" | 9000
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Susan
 | class="sshl_f" | 37
 | class="sshl_f" | 4000
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Jill
 | class="sshl_f" | 45
@@ Line 80: / Line 96: @@
-=DMAX(A4:C10,"Salary",D1:D2)   : Calculates the maximum value in the range A4 to C10, from the cells in the Salary column where Age>32. ''Returns '9000''' as a result.
+=DMAX(A4:C10,"Salary",D1:D2)   : Calculates the maximum value in the range A4 to C10, from the cells in the Salary column where Age>32. <br>Returns '''9000''' as a result.
-=DMAX(A4:C10,2,A1:A3)   : Calculates the maximum value in the range A4 to C10, from the cells in the second column (Age) for all employees. ''Returns '45''' as a result.
+=DMAX(A4:C10,2,A1:A3)   : Calculates the maximum value in the range A4 to C10, from the cells in the second column (Age) for all employees. <br>Returns '''45''' as a result.
-=DMAX(A4:C10,"Age",B1:B3): Calculates the maximum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. ''Returns '45''' as a result.
+=DMAX(A4:C10,"Age",B1:B3): Calculates the maximum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. <br>Returns '''45''' as a result.
-=DMAX(A4:C10,3,A4:C10): Calculates the maximum value in the range A4 to C10, from the cells in the Salary column for all the employees. ''Returns '9000''' as a result.
+=DMAX(A4:C10,3,A4:C10): Calculates the maximum value in the range A4 to C10, from the cells in the Salary column for all the employees. <br>Returns '''9000''' as a result.
 ==Related Videos==

← Older revision		Revision as of 20:29, 17 April 2015
Line 87:		Line 87:

	=DMAX(A4:C10,3,A4:C10): Calculates the maximum value in the range A4 to C10, from the cells in the Salary column for all the employees. ''Returns '9000''' as a result.		=DMAX(A4:C10,3,A4:C10): Calculates the maximum value in the range A4 to C10, from the cells in the Salary column for all the employees. ''Returns '9000''' as a result.
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|eiIAd5xU3Vo\|280\|center\|DMAX}}

	== See Also ==		== See Also ==

@@ Line 84: / Line 84: @@
 =DMAX(A4:C10,2,A1:A3)   : Calculates the maximum value in the range A4 to C10, from the cells in the second column (Age) for all employees. ''Returns '45''' as a result.
-=DMAX(A4:C10,"Age",B1:B3): Calculates the maximum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30].''Returns '45''' as a result.
+=DMAX(A4:C10,"Age",B1:B3): Calculates the maximum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. ''Returns '45''' as a result.
 == See Also ==

@@ Line 20: / Line 20: @@
 == Examples ==
 Consider the following table with Employee names, Age and Salary columns.
 Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.

@@ Line 76: / Line 76: @@
-=DMAX()   :
+=DMAX(A4:C10,"Salary",D1:D2)   : Calculates the maximum value in the range A4 to C10, from the cells in the Salary column where Age>32. ''Returns '9000''' as a result.
-=DMAX()   :
+=DMAX(A4:C10,2,A1:A3)   : Calculates the maximum value in the range A4 to C10, from the cells in the second column (Age) for all names. ''Returns '45''' as a result.
-=DMAX()   :
+=DMAX(A4:C10,"Age",B1:B3): Calculates the maximum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30].''Returns '45''' as a result.
 == See Also ==