Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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