IBM Support

Wrong currency conversion rates (for example rounding down from 8.765 to 8.000) after running a consolidation, caused by Regional Settings (for example Slovenian "Current language for non-Unicode programs" setting)

Troubleshooting


Problem

User clicks "Group - Reports - Currency Translation". User chooses parameters and runs a 'Currency Translation Report'. On the far right-hand side, the rates are shown. These look incorrect.
Because the rates are incorrect, other reports show incorrectly-calculated values.

Symptom

For example, the rates appear to have been rounded down to the lower integer value (correct to 3 decimal places).
Example:
  • Correct value = 8.765
  • Incorrect (bad) rounded-down value = 8.000

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"ARM Category":[{"code":"a8m0z000000GmwiAAC","label":"Consolidation"}],"ARM Case Number":"TS004134502","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
09 May 2025

UID

ibm16328137