I've got a Beast Mode I built and it calculates as expected except that instead of returning the sum value of all matches it returns a row for each match.
Here is the Beast Mode:
SUM(Case when `title`IN ('Metal Technician','Refinish Technician','Frame Technician','Prepper','Mechanic')
then
(Case when YEARWEEK(`hireDate`)<=YEARWEEK(CURDATE()) And `dateOfTermination`is null
Then 1 Else 0
End)
End)
Here is an example of what gets returned, it should have a single Row showing the value of 10, not multiple Row. Any help would be appreciated.
Thanks
Randy
