Skip to main content
Best answer

Filter On Exact Number

  • March 15, 2020
  • 1 reply
  • 578 views

Forum|alt.badge.img
  • Beginner
  • 20 replies

I need to create a filter that checks for an exact number value. E.g., 23.567.

The Zapier filter does not have a ”(Number) Equal to” expression. Only “Greater than” or “Less than.”

The “(Text) Exactly matches” expression does appear to work for a floating-point number, but is that the correct method to use considering that I am actually comparing a number and not text?

 

Best answer by Liz_Roberts

Hi @RonW ,

Thanks for reaching out!

To check for an exact number, you will need to set two filter criteria (“Number Greater than” and “Number Less than”) using the “and” option:

https://zappy.zapier.com/c14b26b8afd72c1efcf729019a970f01.png

 

Let us know if that does the trick! Happy to answer any additional questions you may have!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Liz_Roberts
Forum|alt.badge.img+8
  • Zapier Staff
  • 1366 replies
  • Answer
  • March 16, 2020

Hi @RonW ,

Thanks for reaching out!

To check for an exact number, you will need to set two filter criteria (“Number Greater than” and “Number Less than”) using the “and” option:

https://zappy.zapier.com/c14b26b8afd72c1efcf729019a970f01.png

 

Let us know if that does the trick! Happy to answer any additional questions you may have!