Different result from expected same expression

Broly — Mon, 20 Dec 2021 21:08:46 GMT

Hi guys,

here is the script which I am using:

LoadPerf:
load Distinct
SHIPMENT_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?

topic Different result from expected same expression in App Development

Different result from expected same expression