topic Problem with exchange rate calculation in QlikView https://community.qlik.com/t5/QlikView/Problem-with-exchange-rate-calculation/m-p/747823#M266829 <HTML><HEAD></HEAD><BODY><P>Hi all - I have a strange problem with exchange rate calculations I am hoping someone can point me in the right direction.</P><P></P><P>I am coverting from the local currency of the company into USD in the example below.&nbsp; You can see the GBP amount gets converted perfectly, but the value that is already in USD and so should be getting multiplied by 1 to get the exact same value is not working:-</P><P></P><P><IMG alt="tables.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71250_tables.PNG.png" /></P><P>The expression is simply the revenue in local currency * PRate:-</P><P><IMG alt="expression.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71251_expression.PNG.png" style="width: 620px; height: 241px;" /></P><P>The PRate is joined to the data model using a PRate key which is the local currency and calendar year/month:-</P><P><IMG alt="model.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71256_model.PNG.png" /></P><P></P><P>What could be causing the expression which is taking a value and multiplying it by 1 to get it so wrong?</P><P></P><P>Many thanks in advance.</P><P>S.</P></BODY></HTML> Fri, 14 Nov 2014 10:35:07 GMT 2014-11-14T10:35:07Z Problem with exchange rate calculation https://community.qlik.com/t5/QlikView/Problem-with-exchange-rate-calculation/m-p/747823#M266829 <HTML><HEAD></HEAD><BODY><P>Hi all - I have a strange problem with exchange rate calculations I am hoping someone can point me in the right direction.</P><P></P><P>I am coverting from the local currency of the company into USD in the example below.&nbsp; You can see the GBP amount gets converted perfectly, but the value that is already in USD and so should be getting multiplied by 1 to get the exact same value is not working:-</P><P></P><P><IMG alt="tables.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71250_tables.PNG.png" /></P><P>The expression is simply the revenue in local currency * PRate:-</P><P><IMG alt="expression.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71251_expression.PNG.png" style="width: 620px; height: 241px;" /></P><P>The PRate is joined to the data model using a PRate key which is the local currency and calendar year/month:-</P><P><IMG alt="model.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71256_model.PNG.png" /></P><P></P><P>What could be causing the expression which is taking a value and multiplying it by 1 to get it so wrong?</P><P></P><P>Many thanks in advance.</P><P>S.</P></BODY></HTML> Fri, 14 Nov 2014 10:35:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-exchange-rate-calculation/m-p/747823#M266829 2014-11-14T10:35:07Z Re: Problem with exchange rate calculation https://community.qlik.com/t5/QlikView/Problem-with-exchange-rate-calculation/m-p/747824#M266830 <HTML><HEAD></HEAD><BODY><P>Can you post a document that demonstrates the problem?</P></BODY></HTML> Fri, 14 Nov 2014 10:51:09 GMT https://community.qlik.com/t5/QlikView/Problem-with-exchange-rate-calculation/m-p/747824#M266830 Gysbert_Wassenaar 2014-11-14T10:51:09Z