In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Excel formula to alteryx

Khristian_Evans
8 - Asteroid

Need help converting this excel formula into alteryx format

 

=IFERROR(P2+0,””)

 

P2 would represent the column header, I know what to put in place of that

 

Thanks! 

3 REPLIES 3
binuacs
21 - Polaris

@Khristian_Evans I am not sure there is a specific error catching function in Alteryx like excel, but if you could provide your input file and requirement we can create a function similar to what you are looking for

Khristian_Evans
8 - Asteroid

Here you go! Let me know if that helps. Thanks!

binuacs
21 - Polaris

@Khristian_Evans you can check for the NULL values since you are dealing with dates

image.png

Labels
Top Solution Authors