Incredible. Thank you SO much for that effort. I truly appreciate it.  

That's great. thanks for the guidance!

Thanks Paul.Any resources on what that code might look like? I run a store for a living, not code. I have no idea how to code a comparison or split the orders and return the data I need for a subsequent condition.

Thanks a ton for this, Drew.I guess my next question is how to I then do the comparison from order 1 to order 2 after completing the query?What I've tried here is adding the condition that one of the orders from the list that is generated is >$728 (m...

I want to trigger a workflow when a customer makes an order and it's their 2nd (or 3rd) order.Specifically I am trying to figure out if the first order is above $X amount and the second order is below $X amount so that I can then respond to that cust...