Problem with picking the previous process in script

peschu123 — Fri, 15 Nov 2013 10:19:07 GMT

Hi,

I want to calculate the days between operations in an order.

The table contains multiple Orders with each multiple operations.

So I use in the first step:

[Start Operation] - peek([End Operation],-1)) AS [DaysWaiting]

Until this point it works pretty well. But the first operation takes the End Date from the last operation of the previous order.

To fix this I thought it could be done with:

IF(%ORDER = previous(%ORDER),[Start Operation] - peek([End Operation],-1), null()) AS [DaysWaiting]

But it totally messes up the dates :-/. The table is sorted by Order, Operation ...

Has anybody a clue what I'm doing wrong?

Regards,

Peter

Re: Problem with picking the previous process in script

peschu123 — Fri, 15 Nov 2013 11:43:29 GMT

I had to do a resident load of the same table with "Order By ..." and now it works...