Hello everyone.
How to apply 'ends with' logic in Advanced filter control. This option is absent in drop-down.
Thank you.
Solved! Go to Solution.
Here's what I would do:
Create a text parameter called "Ends With" and use that in an input box control.
Create a calculated field called "Matches" that looks something like this (where TextField is the field you want to match on Ends With):
IF(RIGHT_TEXT(TextField, LENGTH(Ends With))=Ends With, TextField, null)
If you use the Matches field in a table, it will return only the TextField values that end with your Ends With entry. (You can put a filter on the table to exclude the null record.)
Here's my quick example.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |