Skip to main content
Best answer

Filter On Exact Number

  • March 15, 2020
  • 1 reply
  • 665 views

Forum|alt.badge.img

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!

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
  • 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!