Average in ssrs 2008 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Average in ssrs 2008

Author

Topic

Vadz
Starting Member

11 Posts

Posted - 2012-11-13 : 14:57:35

Hi,

I try =AVG(Fields!items.value) still not give the exact average value but give me the value that i want to take the average.any other ways on how to calculate the average value? 365 in in my database so how can i find the average value using my ssrs expression.

thanks in advance

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-11-13 : 15:45:10

Specify the dataset name also - for example

=AVG(Fields!items.value,"DataSet1")

Vadz
Starting Member

11 Posts

Posted - 2012-11-13 : 17:09:17

hi sunita

i try that still not give me the right value..if i use that expression as u mention like 365 to take the average value still give me 365.nothing changes..

LarryC74
Yak Posting Veteran

94 Posts

Posted - 2012-11-17 : 18:33:29

What's the data type fot that field?

Try:
=AVG(Cint(Fields!Items.value))

Everyday life brings me back to reality

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources