I am getting null returns when I use the IF statement that you kindly prepared for me. The syntax looks correct and I have even stripped it back for troubleshooting purposes however it is still the same - see code below.
There are plenty of records that meet this criteria. Even if there werent't I should be getting 0 rather than null.
Any ideas please?
,sum(if(CategoryDescription='Financial', 1-(PercentComp/100), NULL))