Hi Guys I am creating a saved search for Currency ...
# general
a
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
does it have a currency join in the saved search? If so can you join to the name field?
r
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
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.
👍 1