I have a calculation that computes the total number of days to complete an item. The name of the field is Days to Complete. I am trying to get an average number of days per product but no matter what i put in the expression it asks me to input a amount for Days to Complete when I run the report. I have tried Count, Sum and Avg. The expression I am using to calculate the Days is:
=DateDiff("d",[Date Rcd],[Date Completed])
Shouldn't I just be able to put =count([Days to Complete]) in the control source and it add them up?