I'm trying to implement a Choice Filter Web App to filter the shown list entries based on the selection within the Choice Filter.
My list contains the column
Product Version which is of the form
2.03.001. The formula for the calculated column is
=LEFT([Product Version],INT(FIND(".",[Product Version])-1)) and calculates to
2 for the former example.
However, the list is always empty as soon as I select the option
2 (or any other) in the Choice Filter. On the other hand, if I switch Consumer Field Name to
Product Version and add the option
2.03.001 to the list of choices, I get the corresponding list entry as expected.
What am I missing here?