Question

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



Sponsored



Replies

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:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?category=visualstudio&forum=ssdt&filter=alltypes&sort=lastpostdesc