Display UPS, FedEx and USPS separately as Shipping Carrier in Transaction Saved Searches

To display UPS, FedEx and USPS separately as Shipping Carrier in Transaction Saved Searches, users can add the following a Formula (Text) under Results tab > Columns sub tab.

 

Formula = case when {shipmethod} like 'UPS%' then 'UPS' when {shipmethod} like 'FedEx%' then 'FedEx' when {shipmethod} like 'USPS%' then 'USPS' else '' end