Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop 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