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