Yes, indeed! In and Not In filter types support Numbers and Decimal data types.
As you know, In and Not In filter types can be used to match for a field that is either equal or not equal to one of the given values ensuring that the values are separated with a comma.
Note that signed integers (+ and -) are recognized and can be used as values when using In/Not In filter types.
In case a user has to type in multiple Number and Decimal values, ensure to separate each value with a comma.
In case a user has a set or list of number values to be included on the field value, ensure that the number values are separated with a comma before copying and pasting to the field value.
Upon doing so, each number value will be tagged as a single value and will be automatically sorted ascendingly.
In case a user has high number values (e.g. 1,800 or 1.800), where the thousand separator is needed, what should be done? Since a comma (,) is the default delimiter of In and Not In filter types and dot (.) for decimal points, neither should be included for the number value (eg. 1800).
Related Articles:
Comments
0 comments
Please sign in to leave a comment.