Dev Space

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

ifError formula simplified

AS
8 - Asteroid

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

 

11 REPLIES 11
AS
8 - Asteroid

Thanks you so much both of you...

atcodedog05
20 - Arcturus

Happy to help : ) @AS 

Cheers and have a nice day!