Average Calculation

[rrahu07]

can someone please help me to calculate average of between line 1 and line 2, then line 2 and line 3, line 3 and line 4? Also, I want to make sure in moving average calculation I am not combining last time entry of the day and the first entry of next day.

Name	Time
A	9:01:00
A	9:02:18
A	9:05:56
A	9:06:43
A	9:07:25
A	9:08:48
A	9:12:01
A	9:21:12
A	9:34:29
A	9:40:37
B	9:01:00
B	9:02:18
B	9:05:56
B	9:06:43
B	9:07:25
B	9:08:48
B	9:12:01
B	9:21:12
B	9:34:29
B	9:40:37

I tried using this expression on multi-row formula, but i am getting.

iif (IsNull([Row-1:Time]),[Row-1:Time],([Row-1:Time]+[Row-1:Time])/2)

what am i doing wrong?

[grazitti_sapna · Accepted solution]

@rrahu07, as I mentioned above you mentioned only time so my workflow was working based on Employees now I have updated it please try the new workflow.

I hope this helps!

Thanks!