Writing correct Formula

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

hey @Shayna1

Please find attached,

Cheers,
TheOC

Shayna1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703