Sum - Revision history

Cg_pham at 07:18, 17 February 2012

2012-02-17T07:18:55Z

← Older revision		Revision as of 07:18, 17 February 2012
Line 1:		Line 1:
	{{HelpFiles}}		{{HelpFiles}}

	==== sum ====		== sum ==

	Gets the sum of a set of expressions. The values of all parameters must be convertible to numbers.		Gets the sum of a set of expressions. The values of all parameters must be convertible to numbers.
Line 19:		Line 19:
	'''Examples'''		'''Examples'''

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

	''print(a); ''		''print(a); ''

	''//a = 16 ''		''//a = 16 ''

	'''Availability'''		'''Availability'''

Cg van at 08:03, 22 December 2011

2011-12-22T08:03:21Z

← Older revision		Revision as of 08:03, 22 December 2011
Line 1:		Line 1:
	~~[[Category:Math_Functions]]~~		{{HelpFiles}}
	{{HelpFiles}}
			==== sum ====

	~~====~~sum~~====~~		Gets the sum of a set of expressions. The values of all parameters must be convertible to numbers.

	~~Gets the sum of a set of expressions. The values of all parameters must be convertible to numbers.~~		'''Syntax'''

	''~~'Syntax'~~''		sum(''exp1, exp2, exp3, ''…)

	~~sum(~~''~~exp1, exp2, exp3,~~ ''…)		'''Arguments'''

	''~~'Arguments'~~''		''exp''i: Is an expression of any type

	''~~exp~~''~~i: Is an expression of any type~~		'''Return type'''

	~~'''Return type'''~~		number

	~~number~~		'''Examples'''

	''~~'Examples'~~''		''number a = sum(1, 2, "3", 4 + 1, 5); ''

	~~number~~ a ~~= sum(1, 2, "3", 4 + 1, 5~~);		''print(a); ''

	~~print(~~a);		''//a = 16 ''

	~~//a = 16~~		'''Availability'''

	~~'''Availability'''~~		Version 4.8 __NOTOC__ <!-- imported from file: 571.htm-->

	~~Version 4.8~~		[[Category:Math_Functions]]
	~~__NOTOC__~~
	~~<!-- imported from file~~: ~~571.htm-->~~

Cg_pham at 09:11, 12 December 2011

2011-12-12T09:11:55Z

← Older revision		Revision as of 09:11, 12 December 2011
Line 1:		Line 1:
	[[Category:Math_Functions]]		[[Category:Math_Functions]]
			{{HelpFiles}}

	====sum====		====sum====

Cg_pham at 06:55, 22 March 2011

2011-03-22T06:55:08Z

← Older revision		Revision as of 06:55, 22 March 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Math_Functions]]

Catglobe: jrfconvert import

2011-03-07T09:06:38Z

jrfconvert import

← Older revision		Revision as of 09:06, 7 March 2011
Line 4:		Line 4:
	====sum====		====sum====

	~~Returns~~ the sum of all ~~row values for a column~~.		Gets the sum of a set of expressions. The values of all parameters must be convertible to numbers.

	'''Syntax'''		'''Syntax'''

	sum(''~~columnName~~'')		sum(''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'''
Line 20:		Line 20:
	'''Examples'''		'''Examples'''

	~~//calculate the~~ sum ~~of ClassBudget~~, ~~class~~ 1 ~~has~~		number a = sum(1, 2, "3", 4 + 1, 5);

	~~number s = sum~~(~~ClassBudget~~) ~~where (ClassId =~~= ~~1);~~		print(a);

			//a = 16

	'''Availability'''		'''Availability'''
Line 28:		Line 30:
	Version 4.8		Version 4.8
	__NOTOC__		__NOTOC__
	<!-- imported from file: ~~767~~.htm-->		<!-- imported from file: 571.htm-->

Catglobe: jrfconvert import

2011-03-07T09:06:00Z

jrfconvert import

New page

[[Category:HelpBooks]]

====sum====

Returns the sum of all row values for a column.

'''Syntax'''

sum(''columnName'')

'''Arguments'''

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

'''Return type'''

number

'''Examples'''

//calculate the sum of ClassBudget, class 1 has

number s = sum(ClassBudget) where (ClassId == 1);

'''Availability'''

Version 4.8
__NOTOC__