Hey all,
I was wondering if I could be able to use the average formula in forms.
I have begin date, end date, agent name, and I would want to take the difference between those dates and returns me the average of calls. I was successfully able to return the difference dates, but I can't get the average to work. Here is what I use for the formula that I use:
IIF(=IIf([End Date]>[Date],DateDiff("d",[Date],[End Date])=Sum([Average wrap]),0). I put this formula inside TEXTBOX inside the form.
I was wondering if I could be able to use the average formula in forms.
I have begin date, end date, agent name, and I would want to take the difference between those dates and returns me the average of calls. I was successfully able to return the difference dates, but I can't get the average to work. Here is what I use for the formula that I use:
IIF(=IIf([End Date]>[Date],DateDiff("d",[Date],[End Date])=Sum([Average wrap]),0). I put this formula inside TEXTBOX inside the form.