Get the previous event_start_dt_tm grouped by account number, event, and day
[_PREVIOUS_EVENT_START_DT_TM]
===
IF
ATTR([FIN]) = LOOKUP(ATTR([FIN]), -1)
AND ATTR([EVENT_CD]) = LOOKUP(ATTR([EVENT_CD]), -1)
AND ATTR(DATETRUNC('day', [EVENT_START_DT_TM])) = LOOKUP(ATTR(DATETRUNC('day', [EVENT_START_DT_TM])), -1)
THEN LOOKUP(ATTR([EVENT_START_DT_TM]), -1)
ELSE NULL
END
Calculate event_start_dt_tm difference in minutes
[_LKP_EVENT_START_MINS]
===
DATEDIFF('minute',[_PREVIOUS_EVENT_START_DT_TM],ATTR([EVENT_START_DT_TM]))
Comments