The case condition should be : case when {type} in ('Credit Memo','Cash Refund')