Difference between revisions of "Array.$$()"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "Array.$$(Function|Array of Functions[,param1,param2,...]) This returns the result of each row of the Array being operated on by the function or array of functions passed. Th...")
 
Line 28: Line 28:
 
|}
 
|}
 
gives row wise sums of each row.
 
gives row wise sums of each row.
 +
 +
 +
Functions can be defined as a string with a variable, say, x. The following shows a calculation done in each row by subracting second from the first element in each row.
 +
 +
a.$$("x[2]-x[0]")
 +
 +
{| class="wikitable"|-
 +
| 2
 +
|-
 +
| 2
 +
|-
 +
| -8
 +
|-
 +
| 2
 +
|}

Revision as of 15:47, 30 December 2016

Array.$$(Function|Array of Functions[,param1,param2,...])

This returns the result of each row of the Array being operated on by the function or array of functions passed. The parameters provided following the function/function array is passed to the function with each row as the first parameter. Used for aggregate functions or functions that apply on each row (such as a spreadsheet calculation).

For example, a=|4,4,1..10|

1 2 3 4
5 6 7 8
9 10 1 2
3 4 5 6

a.$$(SUM)

10
26
22
18

gives row wise sums of each row.


Functions can be defined as a string with a variable, say, x. The following shows a calculation done in each row by subracting second from the first element in each row.

a.$$("x[2]-x[0]")

2
2
-8
2