Forum Discussion
Sharepoint Online Calculated column
Winterkid you've not said where you're putting the rate of exchange in to do the calculation, because in your image you see to have already done the calculation. Is it a lookup to another list that holds the daily exchange rate for each currency? One way you can make life easy for yourself if you just do a calculated column with cost*rate and if the currency is SGD then the rate is 1 as in my example image below.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott thank you for your fast reply.
the exchange rate will be key in from powerapp application itself from my finance members.
as our currency default is SGD my finance colleague will not be going into the application to manually key 1 into the exchange rate as it serve no purpose for them by doing so.If i set the default value 1 to the exchange rate then it will appear and calculate all the value which will provide false data to the employee before finance colleague update the exchange rate.
hi anyone can help me with me on this.
- Keying in exchange rates leads to user errors. You would be better to have a list with all the currencies and current exchange rate as a data source. Put that in a gallery on a screen in your app so you can update the exchange rate on a daily basis or however often you do it. Then in your main screen your users would select the currency from a dropdown and it would add the rate in automatically and do whatever calculation you need. This could be a formula so that if the dropdown.Selected.Value = "SGD" then it multiplies it by 1 otherwise it multiplies your total by the exchange rate. Or in your currencies list you just have one otem as SGD with the rate as 1 which would never need to change.
