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.
| Author |
Topic |
|
sz1
Aged Yak Warrior
555 Posts |
 Posted - 2012-12-03 : 09:43:09
|
| HiIm trying to do a simple and function with the expression:=AVG(Fields!Day_Average.Value, "OpenCalls_24_0") AND Fields!ASSIGNED_GRP_NAME.Value = 'Level1'))can someone help please?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-03 : 10:05:02
|
sounds like this?=AVG(IIF(Fields!ASSIGNED_GRP_NAME.Value = 'Level1',Fields!Day_Average.Value,Nothing), "OpenCalls_24_0") ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2012-12-03 : 10:15:43
|
| Getting error with this:=AVG(IIF(Fields!ASSIGNED_GRP_NAME.Value = 'L1 All Towers',Fields!Day_Average.Value,Nothing), "OpenCalls_24_0"))) There is a syntax error in the Value expression for the textrun ‘Textbox31.Paragraphs[0].TextRuns[0]’: ‘)’ expected |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-03 : 10:25:30
|
| please use it as suggested. you have lot of unwanted )s=AVG(IIF(Fields!ASSIGNED_GRP_NAME.Value = 'L1 All Towers',Fields!Day_Average.Value,Nothing), "OpenCalls_24_0")------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2012-12-03 : 11:08:50
|
| Thank you...:) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-03 : 11:24:19
|
| welcomealso 'L1 All Towers' should be "L1 All Towers"------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
And =