Sum values of one column in grid widget.

Hi,

I don't know if you found a solution to you question, but I will tell you how I would do.

I would create a service where I get all the values I want to sum up (eg. use same service that is getting values in the Grid). I assume the values are in an infotable, I would use snippet for Aggregate to sum its elements:

• In the service editor, on the Snippets tab, find and add the Aggregate snippet and modify it to the following:

var params = {
	t: myInfoTable/* INFOTABLE */,
	columns: "myColumn" /* STRING */,
	aggregates: "SUM" /* STRING */
};
var result = Resources["InfoTableFunctions"].Aggregate(params);

• Access your desired SUM of a column by using the following syntax of  "SUM_" pre-pended before the infotable column name, example:

result.SUM_myColumn;

  The result should be bind with the text box widget value.

Hope it helps,

Raluca Edu