Noodle EnterColumnarSum() Method

Add a field sum to the columnar portion of a data view.

The data contained in the column specified by bfi is assumed to be numeric. The column values are summarized into a single value rather than displayed individually.

One must call InitializeView prior to adding fields to a data view.

Syntax

EnterColumnarSum(bfi)

Parameter Values

Parameter	Description
bfi	Index of the field to add to the columnar detail

Example

var items = [
  ["1","Vegetable","Tree","1"],
  ["2","Animal","Bird","1"],
  ["3","Mineral","Diamond","1"],
  ["4","Vegetable","Flower","1"],
  ["5","Vegetable","Grass","1"],
  ["6","Animal","Cat","1"],
  ["7","Animal","Dog","1"],
  ["8","Mineral","Ruby","1"],
  ["9","Mineral","Quartz","1"]
];
var db1 = new Noodle(items, ["Seq","Category","Item","Count"]);

// Create a new data view, Category Count
db1.InitializeView();
db1.EnterColumnar(2);
db1.EnterColumnarSum(4);
db1.GenerateView();