So, I added the Advanced Filter as suggested:
( c.`cb_transferedfrom` != '' AND c.`cb_transferedfrom` IS NOT NULL )
Now I am getting a 1054 page with this error:
1054 - Unknown column 'c.cb_transferedfrom' in 'where clause' SQL=SELECT COUNT( DISTINCT u.id ) FROM ngm19_users u JOIN ngm19_user_usergroup_map g ON g.`user_id` = u.`id` JOIN ngm19_comprofiler ue ON ue.`id` = u.`id` WHERE ue.approved = 1 AND ue.confirmed = 1 AND g.group_id IN (0, 1, 38, 32, 29, 27, 41, 30, 9, 28, 6, 7, 35, 36, 40, 34, 37, 2, 3, 4, 5, 10, 17, 15, 14, 11, 12, 39, 16, 13, 18, 19, 25, 26, 21, 23, 22, 20, 24, 42, 8, 31) AND ( c.`cb_transferedfrom` != '' AND c.`cb_transferedfrom` IS NOT NULL )
The field exists.... i don't know what its trying to do but it appears its saying that the field doesn't exist.