Scaling factor in Report Services

[jethrothul]

Hi,

I wonder if anybody has any idea if it is possible to achive a scaling factor for metrics in Report Services without having to create new metrics. In the report I created derived metrics such a 'Sales / 1000'. Such derived metrics are not available in Report Services (is this a 'bug'?).

Thanks

 

[kpescatore]

The only way I have been able to create derived metrics is by create a grid in the detail header section. Then go into grid edit mode. At this point you can add your derived metrics the same as in the desktop interface.
FYI There is also a problem in 7.5.0 with custom groups. The fix is in 7.5.1

 

[entaroadun]

Just format the Sales metric with a format code of "0,". The comma after the ones decimal place causes the metric to display in thousands. 22,700 becomes 22.7.

You don't need derived metrics for this.