We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Create ISERROR function

I recently had an error in a module because an expected variable was not present coming into a formula tool.  My variable, "MONDAY" was not present and the formula MONDAY/3 failed.  The workaround was to union all days into the incoming data and things worked fine.  I would have liked to have an Excel formula like this instead:

 

IF ISERROR([Monday]/3) THEN 0 ELSE [Monday]/3 ENDIF

 

Thanks

3 Comments
StephenR
Alteryx
Alteryx

This would be really useful.  It's just like the Try:Except in Python.  It can be used to send specific error messages with anticipated errors, or like above, deal with a known exception without killing the workflow.

TammyFoley
7 - Meteor

I agree.  I use the ISERROR formula in a lot of my reporting and would not be able to complete the reporting in Alteryx without this ability.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes