community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.
SOLVED

ifError formula simplified

AS
8 - Asteroid
‎08-06-2021 08:13 AM

Hi Guys,

 

Help me in solving this

=IFERROR([@[Last order date in MEA ID]]-[@[First order date in MEA ID]],"NA")

AY2=31-05-2021

=IFERROR($AY$2-[@[First order date in MEA ID]],"NA")

 

Tried first one but getting error help me please

 

Thanks in advance

 

Preview file
14 KB
Reply

Accepted SolutionSolved! Go to Solution.

11 REPLIES 11
AS
8 - Asteroid
‎08-06-2021 09:18 AM

Thanks you so much both of you...

Reply
atcodedog05
22 - Nova
22 - Nova
‎08-06-2021 09:19 AM

Happy to help : ) @AS 

Cheers and have a nice day!

Reply
0 Likes