If the values are null it will return null. Are you sure those values exist? If not consider using NVL or a CASE statement to handle the option.