Help with filtering Null Value

smike626

Hi,

I am creating a beast mode case when statement.

sum(case when `lgract` = '4001'  

then `crdamt`end )

-

sum(case when `lgract` = '4001' 

then `dbtamt`end )

What I need help with is sometimes crdamt returns a null value. I would like it to revert to a 0 value in this case. I believe I need to use NULLIF(crdamt, 0)

However I am unsure where to plug that in to the equation.

Any help is appreciated!

MarkSnodgrass

Try this:

sum(case when `lgract` = '4001'  
then IFNULL(`crdamt`,0) end )
-
sum(case when `lgract` = '4001' 
then `dbtamt`end )