Set default currency as USD but allow local currency in one field

[neilds76]

I have created a custom app and using the price field to capture estimated cost for forecasting, this is in USD however I then need to capture actual cost in a separate field but need this captured in local currency e.g. GBP. 

All the forecasting and actual cost when displayed on data visualisations and dashboards needs to be shown in USD no matter the currency that it is entered for actual cost. 

The system localisation setting 'Use a single currency model. Display all currencies in the same currency code, regardless of a user's locale, country, or language code' is disabled so I can enter the fields in USD and GBP as above but all the data visualisations show in local currency.  If I set this to true I can get the visualisations to show in USD however I can no longer enter actual cost in local currency as this is then locked down to USD.  Does anyone know how I can achieve this?  

[Ankur Bawiskar]

@neilds76 

convert USD to GMP based on conversion rate

If my response helped please mark it correct and close the thread so that it benefits future readers.

[neilds76]

The actual cost needs to be entered in local currency e.g. GBP as the user doesn't know the conversion so won't be able to enter in USD and they will submit cost in local currency so this field needs to be entered in local currency.  It's just all the currency data on data visualisations needs to be in USD but will use the ECB rates to covert what the user enters from local currency in to USD 

[Ankur Bawiskar]

@neilds76 

then in script determine the local currency based on logged in user and then convert it to USD before storing.

If my response helped please mark it correct and close the thread so that it benefits future readers.