Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

MIN & MAX

Highlighted
7 - Meteor

Hi all

 

I am just trying to put min or max formula to identify prior and current date as I have two different COB dates

Have put something like this

IF[Close of Business date]= MAX THEN "CURRENT" ELSE "PRIOR" ENDIF

but doesn't seem to be working

 

Please share your thoughts

 

thanks
Ariz

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Edit: that syntax would not work as you described

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Ariz,

 

So you'll want to bring a summarise tool in using a MAX action and append that back to your original data (using an append fields tool). This will create you a new column (of the max date in the data set) which can then be used in a formula tool expression.

 

I'll mock up a quick example.

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Regards,

Jonathan

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Attached is an example workflow,

 

image.png

 

if this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

Highlighted
7 - Meteor

Thanks Jonathan it worked 

Labels