Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
Matrix.Multiply
Multiplies a value with cells in matrix.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| Matrix | 10.3 | Yes | Yes | Yes | Yes | Yes |
MBS( "Matrix.Multiply"; MatrixRef; Value { ; firstRow; lastRow; firstCol; lastCol } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| MatrixRef | The matrix reference number. | $matrix | |
| Value | The value to use for multiplication to all cells. | 1.2 | |
| firstRow | The index of first row. Default is 0. |
0 | Optional |
| lastRow | The index of last row. Default is FM.SQL.RowCount-1. |
5 | Optional |
| firstCol | The index of first column. Default is 0. |
0 | Optional |
| lastCol | The index of last column. Default is FM.SQL.FieldCount-1. |
6 | Optional |
Result
Returns OK or error.
Description
Multiplies a value with cells in matrix.We loop over all rows in all columns for the range and add the given value to the numbers.
If the cell doesn't contain a number, it's converted to a number like GetAsNumber().
See also
Blog Entries
- What is new in the MBS FileMaker Plugin Version 10.3
- Neues MBS FileMaker Plugin 10.3 - Über 6200 Funktionen in einem Plugin
- MBS FileMaker Plugin 10.3 - More than 6200 Functions In One Plugin
- MBS FileMaker Plugin, version 10.3pr1
Release notes
- Version 10.3
- Added Matrix.Multiply function.
Created 28th May 2020, last changed 28th May 2020
Feedback: Report problem or ask question.
Links
MBS Xojo Plugins
