在Linechart中将数据转换为百分比 [英] Turning data to a percentage in Linechart

问题描述

我正在使用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. 

请有人帮忙.

非常感谢

推荐答案

翡翠.该论坛部分仅适用于Visual Studio DirectX图形工具.我无权自己移动线程.但是，如果主持人不愿意提出此要求，您可以在这里询问:

Emeerald. This forum sections is just for the Visual Studio DirectX graphics tools. I don't have permission to move the thread myself. But if a Moderator doesn't come along to move this you could ask here:

这篇关于在Linechart中将数据转换为百分比的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！