Saved search with a criteria depending on the result...
I am shipping some items to customers everyday.
When a shipment to customer is below a certain amount ( 150Eur in my case), we apply some extra shipping charges.
I am basically trying to figure out a way to know which customers should be charged that extra cost.
I created a saved search that would sum the item amounts by customer, but I am trying to add an extra criteria:
to only see the cases when the sum of customer invoice (or IF) for a specific date is below EUR 150.
I hope you guys understand my question.
Thanks in advance,