The local authority has apologised for refusing to disclose the amount in a previous Freedom of Information request.