Sorry if I was unclear, when I run this script, it returns dozens of identical records. I wonder if it is a problem with my JOIN Statements, but am...

CAST(SUM(CASE WHEN STAT_PRODUCTIVITY.Action != 'Folder'

and STAT_PRODUCTIVITY.Action != 'Assigned' THEN Number

ELSE 0 END) AS DECIMAL)/CAST(SUM (Number) AS DECIMAL (10,2))

AS 'Cleared'

My result still comes out as 0.66743119266 (11 decimal...

What I am looking for is no more than 2 decimal places, ideally this would be converted to a percentage.