Malformed If Statement error

Question

Good afternoon,

I am trying to use the logic below but i keep getting a malformed if statement error. What am i missing?

iif(IsNull([actual_ship_dt]),"Pending Delivery",iif(IsNull([delivery_appt_to_dt]),iif([scheduled_delivery_to_dt]<DateTimeToday(), "Delayed (non appt)",iif([apt_rqrd_yn] ="Y","Del Appt Required", iif([scheduled_delivery_to_dt] > DateTimeToday(), "Future Delivery","Status Pending")))

binu_acs · Accepted Answer

@czjames87

IIF(IsNull([actual_ship_dt]),"Pending Delivery",
IIF(IsNull([delivery_appt_to_dt]),IIF([scheduled_delivery_to_dt]<DateTimeToday(), "Delayed (non appt)",
IIF([apt_rqrd_yn] ="Y","Del Appt Required", 
IIF([scheduled_delivery_to_dt] > DateTimeToday(), "Future Delivery","Status Pending")))))

rfoster7 · Accepted Answer

rewritten out of iif syntax and into standard alteryx if elseif endif sytax:

if isnull([actual_ship_dt]) then "Pending Delivery"
elseif isnull([deliver_appt_to_dt])
and [scheduled_delivery_to_dt] < datetimetoday() then "Delayed (non appt)"
elseif [apt_rqrd_yn] = "Y" then "Del Appt Required"
elseif [scheduled_delivery_to_dt] > datetimetoday() then "future delivery")
else "status pending"
endif

alisonpitt · Accepted Answer

Further to what ^^ @davidskaife said, if you stack the formula up, it's a little easier to see:

Spoiler

IraWatt · Accepted Answer

Hey @czjames87,

Two things you missed:

One you needed a true clause in your second if statement and secondly you needed 5 ending brackets )))))

iif(IsNull([actual_ship_dt]), "Pending Delivery",
iif(IsNull([delivery_appt_to_dt]), "",
iif([scheduled_delivery_to_dt]<DateTimeToday(), "Delayed (non appt)",
iif([apt_rqrd_yn] = "Y" , "Del Appt Required" , 
iif([scheduled_delivery_to_dt] > DateTimeToday(), "Future Delivery" , "Status Pending" )))))

HTH,

Ira