Thank you all for the assistance. Final code is:
SELECT TOP (100) PERCENT Home_Club_Num, COUNT(Member_Number) AS MemberCount, CASE WHEN ROUND(CAST(COUNT(Member_Number) AS Decimal(7, 2)) / 100, 0) = 0 THEN 1 ELSE ROUND(CAST(COUNT(Member_Number) AS Decimal(7, 2)) / 100, 0) END AS DelegateAllowance...