Default value in Case calculation not showing up when the source field is empty

Discussion created by CoraWoolsey on Nov 6, 2015
Latest reply on Nov 6, 2015 by CoraWoolsey

I am having trouble with the Case function returning empty values instead of the default value I specified. Can someone help me figure out what I am doing wrong with the Case function?


Here is the calculation:

Case ( Pet_and_Sang = "Channeling" ; "CHN" ; Pet_and_Sang  ≠  "Channeling" ; "NoCHN" ; Pet_and_Sang  =  "" ; "NoCHN" ; "NoCHN" )


This works fine for records with something in the Pet_and_Sang field, but no value is returned when Pet_and_Sang is empty. Shouldn't it be returning the default value I specified of "NoCHN"? I have also tried to make it return this value when Pet_and_Sang is empty.


Thanks in advance!