Davor Budimir asked 11 years ago
Hello Abu,
Sorry, but I have another question. I have a field of "time" type and I do group records. However sum for this type of field is not working correctly (sums up just hours).
code:
$col = array();
$col["title"] = "Efektivno vrijeme";
$col["name"] = "time";
$col["width"] = "100";
$col["align"] = "center";
$col["editable"] = false;
$col["search"] = false;
$col["formatter"] = "datetime";
$col["summaryType"] = "sum";
….
$grid["groupingView"]["groupSummary"] = array(true);
…
Please help,
Davor
Abu Ghufran answered 11 years ago
Perhaps you need to write custom function to calculate sum of minutes in summary
PHP Part …
$col["summaryType"] = "function(val, name, record) { return mysum(val, name, record) }";
JS part…
function mysum(val, name, record)
{
return parseFloat(val||0) + parseFloat((record[name]||0)); // just for e.g.
}
