As long as the data gets exported to an excel file, the customer doesnt care.

I'm not sure what you mean by a view on a report. How would you take a view of the displayed report values.

My field expression looks like this in the report; round(AHD*25.4,2) so only the displayed value is in metric.