Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2   9.3   9.4    Statistic  

Matrix.Sum

Calculates sum value in a matrix column.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
Matrix 9.2 Yes Yes Yes Yes Yes
MBS( "Matrix.Sum"; MatrixRef; Column { ; firstRow; lastRow } )   More

Parameters

Parameter Description Example value
MatrixRef The matrix reference number. $matrix
Column The index of the column.
Default is 0.
0
firstRow Optional
The index of first row.
Default is 0.
0
lastRow Optional
The index of last row.
Default is FM.SQL.RowCount-1.
5

Result

Returns number or error.

Description

Calculates sum value in a matrix column.
You got a record set in memory and we can walk over a column in a given row range to add the sum value.

See also

Blog Entries

Created 8th April 2019, last changed 8th April 2019


Matrix.SetValue   -   Matrix.Text

Feedback: Report problem or ask question.




Links
MBS Xojo Chart Plugins