In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start 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
binu_acs
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!

binu_acs
21 - Polaris

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

image.png

Labels
Top Solution Authors