Create a new calculated field and use this formula instead: REPLACE([UserName],"$\","")
For this, I am making an assumption that your data looks something like this:
..... and so on
Let me know if this doesn't work. Thanks.
This worked perfect. I got the databases to join and the viz is finished. thanks so much.