I'm importing data from SFDC (into desktop QlikSense app) using the QlikSense connector. All works well except I need to deal with currency conversion so that all my revenue related data is in USD.
Per SFDC help SOQL comment "convertCurrency" should do the trick, see their example below. However the command convertCurrency doesn't seem to work in QlikSense.
SELECT Id, convertCurrency(AnnualRevenue)
Any suggestions on how to make this happen?
There is a CurrencyIsoCode in the data as well as shown below
thank you in advance