Skip to main content

I want to filter to the infinity values but am unsure how to do this. I don't want to remove them using an IF statement or the other tricks you can use to have them become zero or empty values. 

The first screenshot shows the data and that there is one value with Infinity. When I try to use the filter condition to equal the infinity value I am unable to enter the word infinity because it only allows numbers. Next I tried to filter to a value greater then the highest value other then infinity and this filters out everything including the infinity value. 

How can you filter to the infinity values?

 

 

 

 

Hey @aylapois!

That seems to be a tricky one. I haven't played around with filters for infinity values yet (I'll try to do so). In the meantime, or as a workaround, wouldn't having a "helper field" on the side which will show 1 if Calc is Infinity and 0 if it is not, work? If so, you could apply the filter to the helper field rather than to Calc.

Mike, Consultant @ Automatic Nation

Yeah I don't think you can filter number fields like that I'm afraid.  Creating a formula field helper like Mike suggested is a clean way to do it, and you could also try converting your calculation field into a text field by adding the following to the formula:

 

& ""

 

Which allows you to filter out the text 'Infinity':

Thanks for the responses. AirTable surprises me with something that seems it should be simple and can do but doesn't. I wanted to check I wasn't missing something. These are great suggestions but I do find it frustrating to have to create a hack to get around something that should be part of normal functionality. 

 

Thanks for the responses. AirTable surprises me with something that seems it should be simple and can do but doesn't. I wanted to check I wasn't missing something. These are great suggestions but I do find it frustrating to have to create a hack to get around something that should be part of normal functionality. 

 


Hi,
I would just filter 'Second'=0 . With 'First'≠0 in order to exclude possible NaN ( 0/0 ) , if needed.

Reply


Terms & Conditions