Hi Chris, Can you provide some Dummy Data like your Situation to Help You? I think It is possible.
see the attached
I would like to see your workbook
in there attached there are 2 sheets - one uses a numeric LOD as a filter the other a yes/no
the numeric returns this
the yes no this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
lod test.twbx 2.5 MB
Thanks. I tried recreating my issue with a far simpler data set and it works fine. I must have a different problem that is causing this.
Glad to help out
I unfortunately cannot publish the actual file that is not working (it's on server and contains confidential data), but this is the attempted replication I made of the problem with a very simple set of garbage data.
It works here, but in my actual file it does this:
Can anyone think of anything in a more complicated file that might cause this error other than a corrupted file? My actual file contains 10 joined tables. Not sure if that would be an issue with this.