# DataGrid calculated ROW (need help)

**URL:** <https://forum.kirupa.com/t/datagrid-calculated-row-need-help/276726>\
**Category:** flash\
**Created:** [December 3, 2008, 12:50am UTC](https://forum.kirupa.com/t/datagrid-calculated-row-need-help/276726 "2008-12-03T00:50:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ramaz](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@ramaz](https://forum.kirupa.com/u/ramaz)\
**Post date:** [December 3, 2008, 12:50am UTC](https://forum.kirupa.com/t/datagrid-calculated-row-need-help/276726/1 "2008-12-03T00:50:52Z")

</div>

hi,  
try to make my own flash CD burner and need help with DataGrid:

// i have two DataGrid: first introducing all media and  
// second one just selected. after selection i need to  
// calculate total time

var leftLayout:Number = 10;  
var topLayout:Number = 30;  
var widthLayout:Number = 680;  
mymt.setSize(widthLayout, 185);  
mymt.move(leftLayout, topLayout);  
mymt.getColumnAt(0).width = 25;  
mymt.getColumnAt(1).width = 160;  
mymt.getColumnAt(2).width = 350;  
mymt.getColumnAt(3).width = 30;  
mymt.getColumnAt(4).width = 50;  
mymt.resizableColumns = true;  
mymt.vScrollPolicy = “auto”;  
var leftLayout2:Number = 10;  
var topLayout2:Number = 230;  
var widthLayout2:Number = 680;  
mygt.setSize(widthLayout2, 165);  
mygt.move(leftLayout2, topLayout2);  
mygt.getColumnAt(0).width = 25;  
mygt.getColumnAt(1).width = 160;  
mygt.getColumnAt(2).width = 350;  
mygt.getColumnAt(3).width = 30;  
mygt.getColumnAt(4).width = 50;  
mygt.resizableColumns = true;  
mygt.vScrollPolicy = “auto”;  
var mymtArray:Array= new Array();  
mymtArray.addItem({NN:“1.”,artist:“First”,description:“Hello”,duration:“03:06”,genre:“pop”});  
mymtArray.addItem({NN:“2.”,artist:“Second”,description:“How are you”,duration: “03:20”,genre:“folk”});  
mymtArray.addItem({NN:“3.”,artist:“Third”,description:“I am OK”,duration:“01:10”,genre:“folk”});  
mymtArray.addItem({NN:“4.”,artist:“Fouth”,description:“But I need help”,duration:“02:20”,genre:“folk”});  
mymtArray.addItem({NN:“5.”,artist: “Fifth”,description:“Please help me”,duration:“05:50”,genre:“folk”});  
mymt.dataProvider = mymtArray;  
// when you select from top DataGrid  
// it copy on bottom one  
this.cellPress = function( evt\_obj:Object )  
{  
var j = mygt.length+1;  
mygt.addItem({NN:j, artist:mymt.selectedItem.artist, description:mymt.selectedItem.description, duration:mymt.selectedItem.duration, genre:mymt.selectedItem.genre});  
for (k=0; k\<mygt.length; k++) {  
myString = mygt.getItemAt(k).duration;  
myArray = myString.split(":");  
var cm = myArray[0]\*60;  
var ts = myArray[1];  
var tts = parseInt(cm) + parseInt(ts);  
time\_txt.text=tts;  
// trace total time in sec working fine (later i will convert it in min and sec  
// it is not a problem …  
// trace(tts);  
// here i tried to make new Array but it tells that  
// object is underfined  
}  
}  
mymt.addEventListener(“cellPress”, this);  
// please give me any suggestion to populated DURATION and get SUM() NUMBER

thanks