I am trying to create an avereage OPH excluding associates that have not been hired for less than 90 days. The code below looks at current date minus hired date < 90 days then 0, else sum(Fields!PDL_Originated.
Value). On the 90th day the associates originated values/hours worked should be included in the average, but only for the days > 90 days since hire date. Any ideas?
=iif(datediff("dd", Fields!date.Value, Fields!hire_date.Value) < 90, 0, sum(Fields!PDL_Originated.Value+Fields!ILP_Originated.Value+Fields!PDL_Renewals.Value+Fields!ILP_Renewals.Value)/sum(Fields!hoursworked.Value)