Multirow formula

Lizbhernan

Hello, can someone tell me what's wrong with my formula?

IF [Employee ID] != [Row-1:Employee ID] THEN "First Leave"
ELSEIF !ISNULL([Absence Date]) AND !ISNULL([Last Day of Leave - Actual]) THENIF [Last Day of Leave - Actual] <= [Absence Date] THEN "Concurrent Leave" ELSEIF ([Last Day of Leave - Actual] - [Absence Date]) >= 0 THENIF ([Last Day of Leave - Actual] - [Absence Date]) <= 14 THEN "New Leave (0-14 days gap)" ELSE "New Leave (15+ days gap or next)" ENDIF ELSE "Not New Leave" endif else "Insufficient Data" ENDIF

Once I add the ENDIF at the end, it starts to grey out towards the bottom  

Can someone help?

binu_acs

@Lizbhernan I am getting a different result after applying the above formula in alteryx 

Note: the excel formula says take teh difference of AbsenceDate and Last Day of LEave - Actual, but i given the opposite way, 

IF [Employee ID] != [Row-1:Employee ID] THEN
    "First Leave"
ELSEIF !ISNULL([Absence Date]) AND !ISNULL([Last Day of Leave - Actual]) THEN
    IF [Last Day of Leave - Actual] <= [Absence Date] THEN
        "Consecutive Leave"
    ELSEIF DATETIMEDIFF([Last Day of Leave - Actual] , [Absence Date],'days') >= 0 THEN
        IF DATETIMEDIFF([Last Day of Leave - Actual] , [Absence Date],'days') <= 14 THEN
            "New Leave (0-14 days gap)"
        ELSE
            "New Leave (15+ days gap or next)"
        ENDIF
    ELSE
        "Not New Leave"
    ENDIF
ELSE
    "Insufficient Data"
ENDIF

Leave Type Classification.yxmd