SOLVED
Excel formula to alteryx
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Khristian_Evans
8 - Asteroid
05-21-2024
06:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
Labels:
- Labels:
- Developer Tools
3 REPLIES 3
binuacs
21 - Polaris
05-21-2024
06:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
05-21-2024
06:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here you go! Let me know if that helps. Thanks!
binuacs
21 - Polaris
05-21-2024
06:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Khristian_Evans you can check for the NULL values since you are dealing with dates
