Array.$$$()

Revision as of 14:45, 30 December 2016 by Joseph (talk | contribs) (Created page with "Array.$$$(Function|Array of Functions[,param1,param2,...]) This returns the result of each column of the Array being operated on by the function or array of functions passed...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

This returns the result of each column 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 column as the first parameter. Used for aggregate functions or functions that apply on each column (such as a vertical 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)

18
22
16
20

gives row wise sums of each row.