Indicators and aggregate functions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Indicators and aggregate functions

Indicators and aggregate functions

Rate Topic

Display Mode

Topic Options

Author

Message

Jeanne Conde

Posted Monday, January 21, 2013 1:52 PM

Forum 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 »

Permissions