I am trying to figure out what string these functions want as the scope. Looking at various posts and this msdn: http://msdn.microsoft.com/en-us/library/ms159225.aspx
It looks like I need to put the group name in quotes. However, when I try and use =sum(Fields!somevalue.value) / RowNumber("Group3") the report doesn't build and shows this error: The Value expression for the text box 'Run_Time4' has a scope parameter that is not valid for an aggregate function. The scope parameter must be set o a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.
I am using SSAS 2008 and SSRS 2008. There are 4 groups and a detailed group.
I have this data as an example of what I want to see:
Ah, I see, I have to give it the scope of the group. So this needed to be "Group4". However, this function is not returning what I want. I want this number (which is the metric on the first row in the table above) to be the average of the total runtime for the runs. Do I need to use a variable for this?
When I do : =sum(Fields!Run_time.Value) / RowNumber("Group4") ... it is the same as Avg(Fields!Run_time.value). I was hoping that RowNumber("Group4") would just return the number of rows in the next group.