Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitUserDAO.java
===================================================================
diff -u -r0f06a3fe1469600b56093d09d01c0922ab1cb3db -ra6764e3396588eb03f7e2c3cb259b6e6879516a0
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitUserDAO.java	(.../SubmitUserDAO.java)	(revision 0f06a3fe1469600b56093d09d01c0922ab1cb3db)
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitUserDAO.java	(.../SubmitUserDAO.java)	(revision a6764e3396588eb03f7e2c3cb259b6e6879516a0)
@@ -131,7 +131,7 @@
 
 	// Basic select for the user records
 	StringBuilder queryText = new StringBuilder();
-	queryText.append("SELECT user.*, COUNT(details.submission_id) numFiles, SUM(details.removed) numFilesRemoved, count(report.marks) numFilesMarked ");
+	queryText.append("SELECT user.*, COUNT(details.submission_id) numFiles, COALESCE(SUM(details.removed),0) numFilesRemoved, count(report.marks) numFilesMarked ");
 	queryText.append(notebookEntryStrings != null ? notebookEntryStrings[0] : ", NULL notebookEntry");
 	queryText.append(" FROM tl_lasbmt11_user user ");
 	queryText.append(" LEFT JOIN tl_lasbmt11_submission_details details ON user.uid = details.learner_id ");