Is [ADJUSTED_AMOUNT] a float? you cannot compare float with null value, try this--
IF ISNULL([ADJUSTED_AMOUNT] ) OR [ADJUSTED AMOUNT] = 0 THEN [PROJECT_TOTAL] ELSE 0 END
A-ha! That was it. Thanks, Suzie! I can see T is going to require a little time to learn all of its ins and outs...!