Symptoms

A Cognos reports has been designed to perform currency conversions as per the Changepoint user guide, but in many cases the exchange rate is wrong. It seems like a multiple (two times, three times, and so on) of the correct exchange rate is applied.


Reason

If the exchange rate has been added as a field into the query and then Cognos aggregates data, an aggregate function (such as total) will also be applied to the exchange rate. 

Resolution

The field with the exchange rate must be set to aggregation = none: