Chalkster Posted May 22, 2011 Posted May 22, 2011 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?
comment Posted May 22, 2011 Posted May 22, 2011 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?
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now