Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
here is the script which I am using:
LoadPerf:load DistinctSHIPMENT_ID,if((A_MDE_LOADING_FINISHED = 0) and LASTACTION_DATA_SOURCE = 'MDE',(num(A_LOADING_CLOSE_TIME) - MinLoadTimeUG ),(num(A_MDE_LOADING_FINISH_TIME) - MinLoadTimeUG )) as ClosingTime
resident temp;
as you can see the last expression is valid, and the one before it is not.
Do you know why is that?