Hi Guys I am creating a saved search for Currency Exchange Rate.
But In that Saved Search we are getting Internal ID for the currencies instead of name.
Can anyone advise me on how can we get Currency Text for that Internal ID ?
t
Tristan Day
10/11/2022, 7:43 AM
does it have a currency join in the saved search? If so can you join to the name field?
r
RJMNS
10/11/2022, 4:29 PM
Unfortunately I don't think you can since there's no currency join. It's annoying. For a hot minute, they had exchange rates as an option in SA Workbooks and they properly had the text of the ISO codes there, but they pulled it out of there for some reason.
a
Anek Porwal
10/16/2022, 10:17 AM
Yep, Thanks Guys @Tristan Day@RJMNS for your time to give me the response.
So for now we wrote a CASE WHEN formula to get the Names, not an efficient solution, but working.