Average column in a matrix

Hi,
I am trying to add an average column to a matrix in report services. I keep
receiving errors about aggregate amounts.
Example
Amount Number of Units Average
10.00 2
?
15.00 3
?
Total: 25.00 5
?You may want to try to explicitly cast the datatype like this:
=Avg(CDbl(Fields!Amount.Value))
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Susan" <Susan@.discussions.microsoft.com> wrote in message
news:6EABA805-17D6-4365-A1E1-474E60775B47@.microsoft.com...
> Hi,
> I am trying to add an average column to a matrix in report services. I
keep
> receiving errors about aggregate amounts.
> Example
> Amount Number of Units Average
> 10.00 2
> ?
> 15.00 3
> ?
> Total: 25.00 5
> ?