It would be `CASE WHEN {pricinggroup} IS NULL THEN...
# general
m
It would be
CASE WHEN {pricinggroup} IS NULL THEN 'Not Applicable' ELSE LISTAGG({pricinggroup} || ': ' || {grouppricinglevel}, '  |  ') END
but that was a side comment, not related to whatever error you were getting