This content has been marked as final.
Show 1 reply
-
1. Re: Avg. Time Calc based on Parameter "As Of Date"
Okechukwu OssaiMay 9, 2017 7:13 PM (in response to Nick Warchol)
Hi Nick,
You are almost there. I only made few changes to the average calculations.
[1 Day Avg.]
IF [Receive Date] = [As Of Date] THEN [Receive Time Calc] END
[1 Week Ag.]
IF [Receive Date] >= DATEADD('day', -6, [As Of Date]) AND [Receive Date] <= [As Of Date] THEN [Receive Time Calc] END
[1 Month Avg.]
IF [Receive Date] >= DATEADD('day', -29, [As Of Date]) AND [Receive Date] <= [As Of Date] THEN [Receive Time Calc] END
[3 Month Avg.]
IF [Receive Date] >= DATEADD('day', -89, [As Of Date]) AND [Receive Date] <= [As Of Date] THEN [Receive Time Calc] END
Hope this helps. See attached workbook in version 9.2
Ossai