Hello!
I have a file that has profit & loss in different currencies (see original data tab). Is there a way that Alteryx can convert each amount in USD. I would like it to look like "how we want the data" tab.
Thank you in advance!
Take a look at this article. It is likely going to require an API as currencies constantly fluctuate.
My expectation is that your company has a standard currency table (whether in a DB or an ERP) which is used for your calculations. You should identify which source is used for this table - and then build a join vs your currency table and this excel file. If you need to access this from say an ERP - you may need to use an API as @cjaneczko - pointed out. If you are using a DB - you may need a query to bring it in. This is all very company speciifc.
Yup, as the other two said - this depends on how your company organizes the currency rates of the date. Even a small decimal place off can impact your P&L significantly, so thread carefully on this.