IFerror

[igarcia7]

How can I create this formula in alteryx?

=IFERROR(IF(M2<1,"NA", IF(N2<1,"NA",DATEDIF(M2,N2,"D"))),"DateDifError")

[EKasminsky]

Do you have sample data behind using this? I'm curious to see what exactly this formula is trying to do and why you want to use IFERROR.

[igarcia7]

See the columns highlighted

[binuacs]

@igarcia7 

IF ISNULL([M2]) OR [M2] < 1 THEN "NA"
ELSEIF ISNULL([N2]) OR [N2] < 1 THEN "NA"
ELSE DateTimeDiff([N2], [M2], "days")
ENDIF