Edit

TableAccumulate (tab, key, value1, ...)

Result Type: Table

Definition: Accumulates values into a table of key/value(s) vectors, allowing you to build your own analysis tables. Each time TableAccumulate is called, it locates the row in table tab whose first value is key, and adds the specified values to it. If no row is found, one is created. You would normally use TableAccumulate in a report For loop when you are stepping through a range of records. Note that the first row of the resultant table contains a heading.

Examples: The following shows how you would use this in a report, with each calculation being a cell calculation with an Ident of MyTable. The first calculation initialises the table; the subsequent ones accumulate a count and a value.


    myTable = CreateTable()
    myTable=TableAccumulate(MyTable, "A", 1, 3.5)
    myTable=TableAccumulate(MyTable, "B", 1, 4)
    myTable=TableAccumulate(MyTable, "A", 1, 2.5)

Resulting table is

ValueValue
A26
B14

Note: The simple form of tableAccumulate(tab) will take a tab and new line delimited text string and return it as a table. The first "column" in the text string will be the keys, and all other "columns" should be numeric.

See Also:

CreateTable: Create an empty accumulator table

Sort: Sort a delimited tabular string

TableAccumulateColumn: Accumulate data in one column for a key

TableFind: Look up a key in the table

TableGet: Extract data for a key or index found with TableFind

Transpose: Transpose a tabular delimited string