@mattb if you are using NS_CONCAT I'm assuming it's a grouped search so try changing

WHEN {pricinggroup} IS NULL

to

WHEN MAX({pricinggroup}) IS NULL