Help with filtering Null Value

smike626
smike626 Member
in Charting

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 Coach

    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.

Categories