sample calc

calc-1.sql

case
  when {{action}} like 'T_%'
    then 'Processing...' -- <-- 1st test
  when {{listing_location_id}} <> '{{profile.default_participant.location.id}}' -- <-- 2nd test
    then 'N/A'
  when {{pre_delivery_verify}} = 'Confirm' and {{action}} <> 'Received' <-- 3rd test
    then 'Assured'
  when {{actor}} = 'Seller' <-- 4th test
    then
      case
        when {{action}} in ('List','Modify','Reject','Cancel')
	  then 'For Sale'
	when {{action}} in ('Retract','Remove')
	  then 'Removed'
	when {{action}} in ('Counter')
	  then 'Counter-offer Sent'
	when {{action}} in ('Confirm','Accept')
	  then 'Sold'
	else 'Unknown Seller action'
      end
    when {{actor}} = 'Buyer'
      then
        case
	  when {{action}} in ('Accept')
	    then 'Needs Confirmation'
	  when {{action}} in ('Counter')
	    then 'Counter-offer Received'
	  when {{action}} in ('Confirm')
	    then 'Sold'
	  when {{action}} in ('Cancel')
	    then 'For Sale'
	  when {{action}} in ('Received')
            then 'Delivered'
	  else 'Unknown Buyer action'
	end
      else 'Unknown actor'
    end