Help with filtering Null Value

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!

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    Try this:

    sum(case when `lgract` = '4001'  
    then IFNULL(`crdamt`,0) end )
    -
    sum(case when `lgract` = '4001' 
    then `dbtamt`end )
    
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.