in our model we receive the exchange rate for the colombian peso not in the correct way.
The colombian peso has to be multiplied by 1000 why the other currencies have to stay the same.
The problem is that if we try to set up a formula we run into problems with the format of the formula and its not accepted by the system.
How we could do this?
COP is not suppose to have decimal places. If you are pulling currency details from underneath SAP BW/ ECC/ S4 system please check if COP is maintained in TCURX table. If COP is missing from the table, system consider 2 decimal place by default. Best way to fix this would be to correct it at the source itself and then put the data in SAC.
Here are couple of note that through some light on your issue:
Another option would be to multiply with ID property whenever you encounter COP, instead of chancing currency table itself. System may not allow multiplication to currency numbers but allow it with ID property field.
If you are updating currency from a flat file , I suggest multiply 1000 at the data wrangling stage or change it in the source file itself.
Note: to access above note you need S-User ID.