0

Can't put two NL's inside IFERROR formula

I am trying to construct a formula that checks if an NL returns an error, and if it does, then it will run another NL and bring through that result.

Both NL's work separately but inside the IFERROR It returns blank.

=@IFERROR((@NL("first","Posted QC Test Line","Result","Document No.",E4,"Property Code","LINENO","DataSource=","NAV")),(NL("first","Posted QC Test Line","Result","Document No.",E4,"Property Code","%LINEREF","DataSource=","NAV")))

0 comments

Please sign in to leave a comment.