Jump to content

This topic is 5003 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have looked around and seen plenty of solutions for filtering text lists but what I am trying to do is basically very simple but I dont seem to find it

Field A contins multiple numeric values per record . What I want to do is find a calculation that I can use to filter these values in each record to be within a specific range of numbers and discard any that fall outside the range

For example Field A contains values of 187561, 188221, 196774, 215545, 216887, 223349 and I want to filter them to values that are >190582 and <217349 so the result would be a reduced value list of 196774, 215545, 216887

Its easy enough to do in a portal with filtering but I need to store the list of filtered values in the record table

Is there a simple way to do this?

Posted

Is there a simple way to do this?

No, I don't think so.

Its easy enough to do in a portal with filtering but I need to store the list of filtered values in the record table

Do you mean you need the calculation field to be stored? Why?

This topic is 5003 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.