You have to apply the ISNULL() function to your outer SELECT statement. That means you cannot use a SELECT *.

Unfortunately, your sample data and your query don't match (columns [Columns] and [ TOTAL] are missing, content of @Columns is not defined).

Otherwise we would have been able to show you an example based on your data.