Here is the text formula I tried: CASE WHEN {transaction.type}='TransferOrder' AND {transaction.transferlocation} = 'Alliance' AND {transaction.status} ='Pending Receipt' THEN {transaction.transactionnumber} ELSE null END