|
Is there a way to make the following statement return the total of all effort. At the moment it gives a list of sum vs case. select sum(effort), CASE WHEN effortandattainment.effort=5 THEN -3 WHEN effortandattainment.effort=4 THEN -2 WHEN effortandattainment.effort=3 THEN 1 WHEN effortandattainment.effort=2 THEN 2 WHEN effortandattainment.effort=1 THEN 3
END from effortandattainment group by case Regards Garry |
