Repair how Domo handles the 'Amount' field from Salesforce

DataMaven

When data from Salesforce via the connector, the 'amount' field comes in as text.  This is because the currency denomination is in this field, along with the value.  There are workarounds which can be done in workbench and beastmodes, but these should not be necessary.  

 

When data from Salesforce is downloaded to Excel, the numeric value and the currency are automatically broken into separate fields.  I don't know how this is done, but perhaps knowing this can help Domo solve this issue.  I have seen a talk about it on the discussion boards.  

 

Thanks!