Hello, Prod Name ListPrice Standard Cost Average ________________________________________________________________ Book 96 78 Shirt 760 700 Laptop 10000 9900 Helmet 650 600 I need to average under the "Average" column, could please let me know the expression. Thanks in advance.

If you only got two columns you could use =(reportitems!listprice.value+reportitems!standardcost.value)/2

Hi, There is AVG() function for calulating average. But, Can you plase add some details for for which fields you want to average? Some more detail for dataset will help in understanding the problem better.- Chintak (My Blog)

Hello Chintak, I need "Standard Cost' and "List Price" average value in the "Äverage" column ( Row Average). Moreover if there is 10 columns like "Standard Cost' and "List Price", etc..., what is the expression to get Average value.My Dataset name is "DataSet1". Guys, could please please provide me suitable solutions for my other posts ( "How to do Group totals and Group Average in the Matrix", and "How to format the data in the Matrix"). many thanks in advance.

Hi Reddy, If Columns are fixed then I would prefer to do Average in Database Stored Procedure and just display on report.So if any column is added/removed, we can change it from SP only. Thanks,Tejas Shah SQL YOGA

Is that possible to do that via T-SQL?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Dimant, Yes we can do it easily as follows: SELECT (Column1 + Column2 + Column3) / 3 --as I used three columns. Isn't it? Thanks,Tejas Shah SQL YOGA

If you only got two columns you could use =(reportitems!listprice.value+reportitems!standardcost.value)/2

yes you are right.. select (([Column1] + [Column2] + [Column3])/3) as Average from table

There are two ways you can do his. 1) With in the reprot. in you Average Coulmn do as below =(Fields!LastPrice.Value + Fields!StandardCost.Value)/2 2) You can write a query in SQL SELECT [Prod Name], SUM(ListPrice), SUM([Standard Cost]), SUM(ListPrice + [Standard Cost])/2 AS Average FROM TableName GROUP BY [Prod Name] in your reprot create a dataset and drag and drop the Average column into Average Textbox. I hope this should help to solve your probelm. All the bestDasari