Hi,
You can uncheck the 'Generate result currency column', it will only generate a column to store the result currency conversion values.
Maybe it is a conversion failure? Set the 'Upon Conversion Failure' to 'Set to NULL' to find the values where it failes and find out why.
If you select 'Ignore' the modeler displays the unconverted value for the corresponding records. And that is probably the case with you :-)
For finding the error: try a fixed type for the source and target currency, maybe something is wrong with the contents of those columns? You can also do that for the conversion date btw.
You are correct by leaving the 'Exchange Rate' empty, you only need to fill this in if you do not want to use the exchange rate from the TCUR-tables but an alternative one.
More info here: https://help.sap.com/viewer/57a523b496cc4531a3676f5d94644899/2.0.02/en-US/3da1c6b9d735423ba248e30a9bcfeee4.html
Btw, out of curosity, why do you multiply the original amount by one?
Add comment