Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sum of the row groups Expand / Collapse
Author
Message
Posted Tuesday, October 1, 2013 1:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 1, 2013 3:23 AM
Points: 1, Visits: 28
Hi
I have problem to calculate sum of rows (groups)

Cell 'Sum2' has been calculated just right, but cell 'Sum1' not.
Cell 'Sum1' has been multiplied as many times than there is rows in the column 'other'.
For the 'cell' 'Sum1' I would like to get only sum of [sumof..

Sum for the cell 'Sum2' has been calculated as: =Sum(Sum(Fields!Sum_Cost.Value, "TEMPLATEID")) but hat does not work with cell 'Sum1'



Thanks


  Post Attachments 
1.JPG (5 views, 41.37 KB)
Post #1500277
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse