avg

when I use =avg( Fields!age.Value ) I get an #Error in the report. The same
thing happens when I use =StDev( Fields!age.Value ).Check the type of the field "age". Avg and StDev only work on numeric
values.
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:5E018B18-65A1-4E31-AFC2-E7A5CA36B0B5@.microsoft.com...
> when I use =avg( Fields!age.Value ) I get an #Error in the report. The
same
> thing happens when I use =StDev( Fields!age.Value ).|||what is the sytax for converting varchar to numeric
"Fang Wang (MSFT)" wrote:
> Check the type of the field "age". Avg and StDev only work on numeric
> values.
> Fang Wang (MSFT)
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> news:5E018B18-65A1-4E31-AFC2-E7A5CA36B0B5@.microsoft.com...
> > when I use =avg( Fields!age.Value ) I get an #Error in the report. The
> same
> > thing happens when I use =StDev( Fields!age.Value ).
>
>|||E.g. =CDbl(Fields!SomeNumericAsString.Value)
Documentation on data type conversion functions is available at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vagrptypeconversion.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:6721A911-BF53-4E54-82D2-2E0FB670CA3C@.microsoft.com...
> what is the sytax for converting varchar to numeric
> "Fang Wang (MSFT)" wrote:
>> Check the type of the field "age". Avg and StDev only work on numeric
>> values.
>> Fang Wang (MSFT)
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> news:5E018B18-65A1-4E31-AFC2-E7A5CA36B0B5@.microsoft.com...
>> > when I use =avg( Fields!age.Value ) I get an #Error in the report. The
>> same
>> > thing happens when I use =StDev( Fields!age.Value ).
>>