I need to find a way to SUM a field where, IF it contains a '0', I want to replace it with some text or any other value.
So the value isn't NULL & NULLIF won't work.
The syntax would be something like 'IF((SUM(Billed_Amount) = '0'), 'No_Charge')).
Thanks for any suggests!
The option you put would work for sure, there is one more way you can do it -