Hi All:
I’m trying to convert some Item Cost objects by my corporate FY2010 Currency Rate Plan. I’ve created two variables:
1. vFXRates:
=If([Currency Code]="AED";3.7778;
If([Currency Code]="ARS";3.5869;
If([Currency Code]="Argentine Peso";3.5869;
If([Currency Code]="AUD";1.6143;
If([Currency Code]="BHD";0.3878;
If([Currency Code]="BRL";2.3849;
If([Currency Code]="Brazilian Real";2.3849;
If([Currency Code]="CAD";1.2727;
If([Currency Code]="Canadian DOLLARS";1.2727;
If([Currency Code]="CHF";1.1926;
If([Currency Code]="CLP";635.7721;
If([Currency Code]="CNY";7.0484;
If([Currency Code]="Chinese Renminbi";7.0484;
If([Currency Code]="COP";0;
If([Currency Code]="CZK";22.2861;
If([Currency Code]="DKK";5.9627;
If([Currency Code]="EEK";12.5153;
If([Currency Code]="EGP";5.7258;
If([Currency Code]="EUR";0.8000;
If([Currency Code]="Euro";0.8000;
If([Currency Code]="GBP";0.7175;
If([Currency Code]="Great Britain Pound";0.7175;
If([Currency Code]="HKD";7.9774;
If([Currency Code]="HUF";238.6216;
If([Currency Code]="IDR";11701.1701;
If([Currency Code]="ILS";4.1807;
If([Currency Code]="INR";50.2765;
If([Currency Code]="ISK";0;
If([Currency Code]="JPY";92.3750;
If([Currency Code]="KRW";1419.1591;
If([Currency Code]="KZT";125.3594;
If([Currency Code]="MAD";8.8713;
If([Currency Code]="MXN";14.7110;
If([Currency Code]="MXP";14.7110;
If([Currency Code]="Mexican Peso";14.7110;
If([Currency Code]="MYR";3.7104;
If([Currency Code]="NOK";7.0914;
If([Currency Code]="NZD";2.0255;
If([Currency Code]="PHP";48.2963;
If([Currency Code]="PLN";3.5622;
If([Currency Code]="PLZ";3.5622;
If([Currency Code]="RON";3.2787;
If([Currency Code]="RUB";36.7680;
If([Currency Code]="SAR";3.8602;
If([Currency Code]="SEK";8.4748;
If([Currency Code]="SGD";1.5535;
If([Currency Code]="Singapore Dollar";1.5535;
If([Currency Code]="THB";35.9727;
If([Currency Code]="TRY";1.6908;
If([Currency Code]="TWD";34.6509;
If([Currency Code]="UAH";8.4962;
If([Currency Code]="USD";1.0000;
If([Currency Code]="US DOLLARS";1.0000;
If([Currency Code]="ZAR";10.4687;
""))))))))))))))))))))))))))))))))))))))))))))))))))))))2. vFY10FX_ItemCostInUSD
=[Order Line Ext Amt]/ToNumber([v_FXRate])When I place vFXRates in the report, the currency rates round to two decimal points (e.g. Should be “GBP = 0.7175” … BO is changing it to “GBP = 0.72”.
I have tried to change the number format to no avail. BO is changing/rounding the number when the variable processes.
Please help… much appreciated.
juliehunt 
(BOB member since 2009-10-01)