Turning data to a percentage in Linechart

Category: visual studio graphics tools


Emeerald on Thu, 25 Feb 2016 02:44:54

I am creating a report using SQL Server Data Tools for Visual Studio 2012.

i)I have checked the underlying data- it is correct

ii)I have brought in my data 

iii)I have created a Calculated field for Growthrate - e.g formula... =(Fields!a.value/Fields!b.value)-1

iv) I need to convert this to  percentage. 

When changing the formula to =(Fields!a.value/Fields!b.value)-1)*100 the Linechart looks messy - not correct. 

n.b. I selected the aggregate/function First(Growthrate) in the Chart Data under Values. 

Please could someone help. 

Many thanks


IanHuff - MSFT on Fri, 26 Feb 2016 21:19:29

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: