cancel
Showing results for 
Search instead for 
Did you mean: 

How to do IF Calculation correctly?

former_member355106
Active Participant
0 Kudos

Hello together,


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?

BR/

Accepted Solutions (0)

Answers (2)

Answers (2)

JefB
Active Contributor
0 Kudos

Is this a calculated measure in a 'new' advanced (planning?) model?
Maybe refer to the ID property of the dimension?

[d/Target_Currency].[p/ID]
former_member355106
Active Participant
0 Kudos

Hello Jef, we dont have the planning license and we also dont use the new model type.

VijayetaSharma
Active Contributor
0 Kudos

Hello oliver76,

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:

137626 - FAQ: Decimal places for currency codes

2689978 - FAQ - Colombian Peso currency set with zero decimal points

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.

Thanks,

Vijayeta

VijayetaSharma
Active Contributor
0 Kudos

Hello oliver76,

Did you find shared info helpful?

Thanks,

Vijayeta