This content has been marked as final. Show 5 replies
Can you try this instead of ifnull and see how it works1 person found this helpful
case when col is null or col='' then 0 else col end
If helps mark
Sorry, it still doesn't seem to be working. Thanks tho
In Column C define Ifnull(Col A) - Ifnull(Col B) Try this.I have tried and it is working for me.
Awesome. Thanks very much! Make my life so much easier!
It works for me aswell. Thanks!!!