Duration and time -fields return sum as hh:mm:ss

Return value

Float

Arguments

$select

Field name or select -definition

Full documentation

Get total amount of new projects:

$totalAmount = $this->get('pages','project')
    ->addWhere('status','New')
    ->selectSum('total_amount');