I want to create a metric of Pivot 2: Actual/Target. But some Target is null. I wrote in Custom SQL as bellow but it not work. I changed to != Null or !=0, it still not work. Please help!

Case
when TARGET is NULL then 0
else SUM(Revenue)*100/Sum(TARGET)
END AS [%Actual/Target]

Thanks and regards

I changed to != Null or !=0, it still not work.