Amount (converted) salesforce field

Could anyone please confirm why Domo does not allow me to select the Amount (converted) field from the Opportunities object in salesforce? It is not even listen as an option when attempting to pull that data by browsing objects and fields. I suspect it might be because it might use a conversion formula not identified/supported by Domo, or maybe there is a way to pull that data? Thanks!
Comments
-
We pull the Opportunity data as one dataset and the ISO Codes and Conversion Rates (from our Salesforce instance) in another data set. We then use a dataflow to recreate the Amount (Converted) field.
I don't know why Salesforce does not expose certain APIs, but this along with Current Stage Age are to fields that we had to manufacture using dataflows in Domo rather than a direct API pull.
1 -
@ST_-Superman-_, Thanks for your reply. This seems to be the way to go. However, the issue now is that this alternative uses the current conversion rate, even for historical data and, thus, skews the data. Any ideas how to go about this? Does salesforce store historical conversion rates?
0 -
Looks like a SOQL query using the convertcurrency() function does the trick!
0 -
@user36203, can you please show how you used that function?
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive