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
7 - Meteor

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
7 - Meteor

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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels