Hi All,
I’m hoping someone can help me on this one. I have a requirement whereby I need to calculate a formula to convert from multiple currencies. For instance I need something that performs the following logic:
If Currency Euro>0 then multiple by exchange rate; OR; Currency USD>0 then multiply by exchange rate; OR; Currency YEN>0 Then multiple by Exchange rate. And so on and so on…
Is this even possible I’ve been wracking my brains over it for a couple of days now.
Any Help appreciated.
Thanks
Craig G
Hi
I once solved this using a currency rate list and a worflow.
If a record was edited or created the workflow kicked off. It read the currency and updated the record based on the value from the currency rate list.
Nowadays I would suggest replacing the workflow with a Microsoft Flow.
Hope this helps.
PS: Besides the fact that I’m personally not really fond of all kind of calculations.
Why not use a tool that is good at that (Access Web App?) and display the values in SharePoint 🙂
Hi Sander, thanks for the pointers. I’ll going to give them a go to see what works best. It’s amazing how blinkered you can get on a single route to a solution 🙂
Thanks for the suggestion Sander
Thanks Sander, Some good ideas in there that I’ll start working on. Typically sometimes you get blinkered on one solution 🙂