I have a column with different currencies, and another column where I want to consolidate these currencies into one (say, USD?). The exchange rates change daily, and the primary consumer of a dashboard I built requested having a box where they could input the exchange rates, which would consolidate the values into new column automatically. Presently, I “hard coded” these exchange rates, and I update them periodically (once a week for the time being) so it reflects current exchange rates. The box idea sounds useful, and even though I have no other examples at hand where this could help, I believe it could be useful in more circumstances.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.