Writing correct Formula

[Shayna1]

I am struggling writing a formula to gather the correct information. 

I am needing to pull the greater value from the 3 columns. 

Same Day - Previous Day - Next Day

if same day is greater than previous or next day then display same. 

or if next day is greater than same and previous then display next and so on. 

[MarqueeCrew]

Have you played with Max() function?

https://help.alteryx.com/designer-cloud/minmax-functions

https://help.alteryx.com/20214/designer/minmax-functions

 Mark

[binuacs]

@Shayna1 please provide some sample data and expected output

[Shayna1]

I haven't just because I wasn't sure I could write something that could pull from all 3 columns at the same time for that max value. 

[MarqueeCrew]

Max([field 1],[field 2],[field 3]) returns the bigger or more recent date.  

[TheOC]

hey @Shayna1 

your formula using the Max function in a formula tool as suggested by @MarqueeCrew, would look like:
Max([Same Day], [Previous Day], [Next Day])

This would produce an output of the maximum value of all three columns.

Cheers,
TheOC

[Shayna1]

My expected output is just to have the greatest value from the 3 columns to be populated in the Greatest BOE Down

NextDay_BOEDown7	Right_PreviousDay_BOEDown7	SameDay_BOEDown7	Greatest BOE Down	DT_Info_SameDay	SameDay_PROD_DATE	SameDay_WellName
8	12	1		Maint DT TOW, No WR/WO in EAM	2/11/2022	ALICO #1
9	100	1		Maint DT TOW, No WR/WO in EAM	2/6/2022	CLONA #1
90	4	0		Maint DT TOW, No WR/WO in EAM	2/7/2022	CLONA #1
1	80	100		Maint DT TOW, No WR/WO in EAM	2/6/2022	LINDSAY #1
0	0	1		Maint DT TOW, No WR/WO in EAM	2/7/2022	LINDSAY #1
1	0	0		Maint DT TOW, No WR/WO in EAM	2/8/2022	LINDSAY #1
0	1	0		Maint DT TOW, No WR/WO in EAM	2/9/2022	LINDSAY #1

[TheOC · Accepted solution]

hey @Shayna1 

Please find attached,

Cheers,
TheOC