cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate MAX value for each Row?

KHK
Partner
Partner

Hi Team,

I Have below requirement to calculate MAX value of 6 columns for each row. Please let me know how to achieve.

sample Data:

KHK_0-1698834916691.png

 

 

 

 

2 REPLIES 2

BrandonR
Partner
Partner

Incorta does have a built in function to find the max between two values. 

It won't be pretty, but using this you should be able to nest them in a way to find the max value between a number of columns. 

max1.PNG

  

max2.PNG

 

Brandon

Thank you @BrandonR , formula working fine.