public function getTotalPrice() { $dql = "SELECT SUM(p.averagePrice * p.stockLevel) FROM PartKeepr\\PartBundle\\Entity\\Part p"; return $this->entityManager->createQuery($dql)->getSingleScalarResult(); }