Hello there, quite a convoluted issue, but will try and explain as succinctly as possible. I've ran a Saved Search to expose differences between Sales order value (net of tax) and Projected Total for the associated Opportunities. They are relatively few and far between. The report uses GBP as the base currency and converts any US Opps/Sales Orders into Sterling, but on these i've noticed small differences between the two figures. When i've checked the SOs and Opp records i've found the US totals match, so assuming that this report is reflecting the FX rate. Is there any way i can get around this, either by adding to my formula, or manipulating the Amount Net of Tax field to reflect this, that way i can pull in Projected Total (Foreign Currency) and hopefully match these up. I've included some screenshots of my columns and the search as it stands, would appreciate any advice, thanks.