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
The simplest way would be using a calculated column. You could build all those if conditions with in your formula. Check out this link.
https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx
Thanks Sander, Some good ideas in there that I’ll start working on. Typically sometimes you get blinkered on one solution đŸ™‚