Use the coalesce function for calculated fields in Amazon Quick.