Text input for currency conversion and total amount

[esabay]

Hi All, 

I have tried to come up with a workflow attached here but I cannot seem to figure out how to add the FX conversion in the text input to properly convert all amounts into EUR. The goal is to have all amounts be converted to EUR and have a total count similar to the below table:

The customer amount row shows the net total of all the amounts for that customer. The customer count is all the number of transaction with customer. The totals are the net total sum of the amounts in the amount and count column. Thank you for the help

Customer	Amount	Count
Bert	1,000,000.00	3.00
Marge	50,000.00	4.00
Homer	200.00	8.00
Total	1,050,200.00	15.00

[aatalai]

Use a join tool connect your FX rate to settle currency column