Hi, does anyone have any insight into this scenario?
I'm trying to create a project report using a dropdown field in the brief. There are 10 options or so in the drop down and the user can only pick one which would make it seem simple to run a report based on the option selected, but it isn't. If I want the report to show Option A information, I can't. It randomly shows other options. For instance Option A, Option D, and Option C might appear. We have edited the field multiple times over the years, so I'm wondering if there is some type of legacy information in the background which is influencing the data I receive.
Any thoughts?
Thank you
