Link to home
Start Free TrialLog in
Avatar of zintech
zintech

asked on

How to do aggregate function in Visual Studio Reporting Services

I need to do an aggregate function to sum the number of hours, which is the data values in the image below.  I need to place the aggregate function where the "#Error" is in the image.  I already tried using the expression "Sum(Fields!Hours.Value)" but this does not work.
\
 User generated image
ASKER CERTIFIED SOLUTION
Avatar of QPR
QPR
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of zintech
zintech

ASKER

It is data type Int64
no more details when in design view?
can you check the formula when in design view (are you using BIDs?)