问题描述
我正在使用SQL Server Data Tools for Visual Studio 2012创建报告.
I am creating a report using SQL Server Data Tools for Visual Studio 2012.
i)我已经检查了基础数据-正确
i)I have checked the underlying data- it is correct
ii)我已经输入了数据
ii)I have brought in my data
iii)我已经为Growthrate创建了一个计算字段-例如公式... =(Fields!a.value/Fields!b.value)-1
iii)I have created a Calculated field for Growthrate - e.g formula... =(Fields!a.value/Fields!b.value)-1
iv)我需要将其转换为 percentage.
iv) I need to convert this to percentage.
将公式更改为=((Fields!a.value/Fields!b.value)-1)* 100时,线形图看起来很乱-不正确.
When changing the formula to =(Fields!a.value/Fields!b.value)-1)*100 the Linechart looks messy - not correct.
n.b.我在图表数据"中的值"下选择了汇总/函数"First(Growthrate)".
n.b. I selected the aggregate/function First(Growthrate) in the Chart Data under Values.
请有人帮忙.
非常感谢
推荐答案
这篇关于在Linechart中将数据转换为百分比的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!