Free Trial

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