79201 - no subject - Hi,\n\nI have a task-based portal report

Hi,

I have a task-based portal report, and on this report, among others, are columns for Task Assigned Time and Task Completion Time.

For Task Assignment Time, I am using the expression:

=if(or(task_status()=1,task_status()=2),task_assignment_time()-Lag(),task_assignment_time())

to calculate, since tasks that have been accepted use the acceptance time for the task_assignment_time() metric.

For Completion Time, I am using the task_completion_time() metric.

However, in some rare cases, the assignment time of a given task is earlier thant the completion time of the prior task, and I wanted to see if anyone might be able to tell me why this might be happening. In most cases, it works great, but I can't for the life of me understand why it's not working in all cases.

Thanks as always in advance....

OriginalPostID-79201