OAC | Filtration - Error

Question

Greetings Community, I'm facing an issue with an error only when I apply a Filter.

So I am able to visualize and put Data side by side from 2 Sources:

It's only when I select a Location, let's say for example "Cambridge", it throws in following error:

Just a FYI, this is how the joining is done:

Please let me know how this can be tackled, as everything is fine until a Filter is applied.

Thank You So Much for your time and efforts.

Vismay Barot · Accepted Answer

Thank You So Much @Jestin Rajan for your Comment.

Please Note 18 is just an Internal ID for My Select Filter for "Cambridge":

Here's the Full List of Sales Representative Location:

I don't think so any Location would be Non-Text Value.

But the Great News is, I created this Calculation:

And will use this as a Filter, this is working perfectly fine.

Thank You So Much and Have a Great Day :)

Vismay Barot · Accepted Answer

Thank You @Jestin Rajan , 18 is basically Internal ID for "Cambridge" Location (ref. Screenshot from above).

However, different approach was pursued so this Case can be closed.

Thank You for your input ☺