Show currency in Quote Report

Question

Dear Sugar Users, 
 My goal is to have the Currency field available in a Quote Report. i.e. List of Quotes, Totals and their Currency. 
 I do not have Currency as a reportable field for Quotes, i.e. I cannot see the Currency field when I build a report. 
 However it is on the Quote Records View Layout in Studio (See below) 
 
 And therefore, visible on the actual Quote Record. (See below) 
 
 I have noticed a few forum posts discussing Currency. Francesca Shiekh has developed a solution in the post below 
 CSV Extraction of currency field - Enterprise & Sell Answers & Best Practices - Enterprise & Sell - SugarClub (sugarcrm.com) 
 And Hugo Geyskens posted Report export to csv currencies - Enterprise & Sell Answers & Best Practices - Enterprise & Sell - SugarClub (sugarcrm.com) 
 I was hoping there might be a cleaner way of doing this? 
 BTW Sugar 12.0.4 Enterprise. 
 Thanks in advance for any tips.

Peter Hallett · Accepted Answer

Hi Peter, 
 I also found that reporting on the related currency is difficult. 
 I think I found an answer to your problem by creating a calculated field that you would then report on and created a quick video to show you how:

The Formula would need to be updated to show the base currency of your system, so it's not perfect. Cheers, James Sugabyte

Peter Hallett · Answer

Hi James Banbury , 
 Wow, a personalised video with the solution, this is perfect. 
 Although there are few issues with using the calculated field with older quotes, this is still a suitable solution. 
 Thanks again. Greatly appreciated.