3499491 - SAP Datasphere currency conversion is not expected with a factor of 100

Symptom

You have a currency conversion column created. The result is wrong and has a factor of 100 for some currencies.

Environment

Datasphere

Reproducing the Issue

Create a currency conversion column.

Cause

This can happen to some currencies, e.g. Japanese Yen (JPY), Korean Won (KRW), Chilean Peso (CLP), Colombian Peso (COP) and other currencies which do not have 2 decimal places. You need decide if converting steps should include "Shift"/"Shift Back" as explained in following guide.
CONVERT_CURRENCY Function (Miscellaneous)

Resolution

Check/Uncheck options "Shift"/"Shift Back" accordingly with referring to guide Create a Currency Conversion Column.

Keywords

CONVERT_CURRENCY, TCURV - Exchange rate types, TCURW - Exchange rate type text, TCURX - Decimal places in currencies, TCURN - Quotations, TCURR - Exchange rates, TCURF - Conversion factors, TCURC - Currency codes, TCURT - Currency text, 10 , KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , DS-MD , Modeling (Data Builder) , How To

Product

SAP Datasphere all versions