execute(input) db = service "database_orders" row = db.first({ from: "PurchaseOrder (id:count, total:sum, total:avg)", where: { deleted: false, "supplier.id": input.supplierId } }) data = row.data() // No contributing values produce null sums/averages, not necessarily zero. amount = data["total:sum"] average = data["total:avg"] if amount == null amount = 0 end if average == null average = 0 end return { orderCount: data["id:count"], amount: amount, average: average } end