I am using the %RT formula in a query and also using the properties of Calculate Single Value As - Normalize Sub Totals. When I do this it automaticly returns the figure to 3 decimal places and adds % at the end.
I have the properties of this formula set to scaling factor of 1 and 0 Decimal places but this doesn't change when the report is run.
This is the only function that returns the correct value for me but I cant change the properties. I need a % for each sub total down my report and the other % formulas only calculate at the report totals not the sub totals.
Any ideas as to how I can change the properties?