Hi Eric,
Did you find the solution for this?
I have the same problem and I would like to know if there´s anyway of doing
it.
Thanks,
Mónica
"eric" <eric@discussions.microsoft.com> escribió en el mensaje
news:2DD05D4D-4B91-4088-B1A9-EA5BF35592B4@microsoft.com...
[quoted text, click to view] > Hi Michael,
>
> Thank you for the response. Unfortunately I get the same error. I have 2
> groups, one to group by parent and the second group to reduce duplicate
> records. The Sum I would like to total the second group values, but only
> the visible records in the group. Any other ideas? Thanks
>
> Eric
>
> "Michael C" wrote:
>
>>
>> Eric,
>> Try this:
>> =RunningValue(Fields!BF_Child.Value,Sum,"table1_Details_Group")
>>
>> Michael C
>>
>> "eric" wrote:
>>
>> > I'm trying to get a sum of values from a group with the following
>> > expression.
>> > =SUM(Fields!BF_Child.Value, "table1_Details_Group"). When I try to
>> > run it I
>> > get the following error.
>> >
>> > [rsInvalidAggregateScope] The Value expression for the textbox
>> > 'textbox7'
>> > has a scope parameter that is not valid for an aggregate function. The
>> > scope
>> > parameter must be set to 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
>> > data set.
>> > Build complete -- 1 errors, 0 warnings
>> >
>> >
>> > Why can't I sum group values?