sum 1 column to footer
I am trying to simply sum the numeric valued column 2 (zero-based) and have it show in footer. can someone please help?
I have added variation on parts of this suggested code to my already existing, well-functioning app. I get jibberish. can someone help me with the correct syntax to sum column 2? what about column 2 and 3?
Thank you.
<script>
var obj = new AW.UI.Grid;
obj.setColumnCount(10);
var number = new AW.Formats.Number;
number.setTextFormat("$ #,###.##");
obj.setFooterVisible(true);
obj.setFooterData("1234567.890", 0);
obj.setFooterFormat(number, 0);
obj.setFooterText(function(i){
var data = this.getFooterData(i);
var format = this.getFooterFormat(i);
return format ? format.dataToText(data) : data;
});
document.write(obj);
</script>
I have added variation on parts of this suggested code to my already existing, well-functioning app. I get jibberish. can someone help me with the correct syntax to sum column 2? what about column 2 and 3?
Thank you.
<script>
var obj = new AW.UI.Grid;
obj.setColumnCount(10);
var number = new AW.Formats.Number;
number.setTextFormat("$ #,###.##");
obj.setFooterVisible(true);
obj.setFooterData("1234567.890", 0);
obj.setFooterFormat(number, 0);
obj.setFooterText(function(i){
var data = this.getFooterData(i);
var format = this.getFooterFormat(i);
return format ? format.dataToText(data) : data;
});
document.write(obj);
</script>
Janie
February 17,