protected string[] calculateRowAVGSD(string [] rowData)
{
string [] rowReturn = new String[sessions.Count +3];
int count =0;
double sumValue = 0;
string valuesList ="";
string separator ="";
if(sessions.Count > 1) {
int i=0;
for (i=0; i < sessions.Count + 1; i++) {
rowReturn[i] = rowData[i];
if(i>0 && rowReturn[i] != "-") { //first column is text
count++;
sumValue += Convert.ToDouble(rowReturn[i]);
valuesList += separator + rowReturn[i];
separator = ":";
}
}
if(count > 0) {
rowReturn[i] = Util.TrimDecimals( (sumValue /count).ToString(), pDN );
if(count > 1) {
rowReturn[i+1] = Util.TrimDecimals( Util.CalculateSD(valuesList, sumValue, count).ToString(), pDN );
} else {
rowReturn[i+1] = "-";
}
} else {
rowReturn[i] = "-";
rowReturn[i+1] = "-";
}
return rowReturn;
} else {
return rowData;
}
}