How to calculate MAX value for each Row?

[KHK]

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:

[BrandonR · Accepted solution]

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. 

  

Brandon

[KHK]

Thank you @BrandonR , formula working fine.