the criteria is just the customers and item record. the formula i was trying to adapt from a saved search that lists all customers and their last transaction date (even those who have not purchased) is: CASE WHEN {type} = 'Invoice' then {trandate} ELSE NULL END