cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Filtering a search to 10 customers

Nesh
Deputy Chef II
Deputy Chef II

I have a recipe where I am pulling invoices from the past 2 years. I want to add a condition where it will only pull records for 10 customers. I have not been very successful in setting up a formula using customer ID's. I have attached a copy of the condition I have currently. Any help is greatly appreciated. Thanks!

 
 

recipeImage.png

2 REPLIES 2

kkamal
Deputy Chef III
Deputy Chef III

equals usually takes a single value for comparison. (as you have provided 2112) 

What are other options for operator selection other than equals ? if there is an option "IN" that might give you further a way to put multiple customer ids and you could use 10 customer ids. 

Your questions seems incomplete. a bit more context would've been helpful. 

Nesh
Deputy Chef II
Deputy Chef II

Thank you for your help! The only operator options I have are below (see screen shot)

So basically, in this recipe, I am pulling past due invoices for all customers in our ERP system dating back two years from today. However, for the first initial testing phase, I want to add a condition/filter where only 10 customers' data is retrieved. This is where I need some help.  Screenshot 2024-06-20 133225.png