SQL Query Transpose not returning negative numbers

I have a table that I am transposing by using a database view (using SQL Server). This table has positive and negative values. All of the negative values are returned as zero. Any ideas on how I can correct this?

Example of my original table:

The result of my transposed view:

This is the SQL script for the view:

SELECT Peak, MAX(CASE WHEN T .YEAR = 2016 THEN T .[Value_A] ELSE 0.00 END) AS Value_A_2016, 
       MAX(CASE WHEN T .YEAR = 2018 THEN T .[Value_A] ELSE 0.00 END) AS Value_A_2018, 
       MAX(CASE WHEN T .YEAR = 2028 THEN T .[Value_A] ELSE 0.00 END) AS Value_A_2028, 
       MAX(CASE WHEN T .YEAR = 2016 THEN T .[Value_B] ELSE 0.00 END) AS Value_B_2016, 
       MAX(CASE WHEN T .YEAR = 2018 THEN T .[Value_B] ELSE 0.00 END) AS Value_B_2018, 
       MAX(CASE WHEN T .YEAR = 2028 THEN T .[Value_B] ELSE 0.00 END) AS Value_B_2028
FROM gisadmin.Table_1 AS T
GROUP BY Peak

Thanks very much for any assistance with this.

>Solution :

MAX(CASE 
    WHEN T.YEAR = 2018 THEN T.[Value_A] 
    ELSE 0.00
END) AS Value_A_2018

The problem is with the else branch, which returns 0 on rows that do not match the year predicate. Obviously 0 is greater than any negative value, so this is what MAX returns, hence "masking" the actual value.

Instead, you can just remove the else branch ; unmatched rows yield null values, that max ignores.

You can still assign a default value of 0 to null columns afterwards with coalesce(), if that’s what you want:

COALESCE(
    MAX(CASE 
        WHEN T.YEAR = 2018 THEN T.[Value_A] 
    END),
    0
) AS Value_A_2018