Hi All, I’m getting weird results when I make a visible expression based on a value in another field. On some results it does what it should but then others in does the calculation even though the ScheduledCategory = 0?? In a nutshell I want to average the two datetimes only when the ScheduledCategory = 1. declare @t table ( ScheduledCategory int , ScheduleDate datetime , CompleteDateCancelled datetime ) insert into @t select 1, '1/1/2011 11:00:00 AM' , '1/1/2011 1:00:00 PM' union all select 0, '1/1/2011 9:00 AM' , '1/1/2011 10:00 AM' union all select 0, '1/1/2011 5:00 PM' , '1/1/2011 6:00 PM' select * from @t In my field called Scheduled Dispatch I have following Expression = Avg(Fields!Schedule_Dispatch.Value) Visibility Expression =IIF(Fields!Scheduled.Value = 1, TRUE , FALSE ) I should mention that the above data will work fine. it's when I work with large data sets that I run into trouble. Nothing like working with reports you can't trust! :) Flexpadawan