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

Indicators and aggregate functions Expand / Collapse
Author
Message
Posted Monday, January 21, 2013 1:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 21, 2013 1:52 PM
Points: 1, Visits: 5
I have a table and 2 columns are calculated columns I want to take the difference between the 2 columns and show an indicator based on that
here is the formula
=(ReportItems!Job_Hours.Value)-(ReportItems!Hours1.Value)
But it says I can't use an aggregate
I have another column that uses this expression but if I try to use it for the indicator I get the same error about aggregates.
=IIF(First(Fields!Job_Hours.Value)=0,"",((Sum(Fields!Hours.Value))/(First(Fields!Job_Hours.Value))))
Does anyone have any suggestions on how to do this? The one field is coming from another data set
Post #1409701
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse