Max Value among 4 fields

[taylorswiftlover]

Hi, I'm trying to generate a calculated value which is the maximum value among the four fields. Do you know how I can achieve that?

MAX ([@field:Cp1]:[@field:Cp2]:[@field:Cp3]:[@field:Cp4]) that's the formula that I've been trying to use. Any help?
 

[SinJunYoung]

For us to get the maximum value for multiple fields, you can try using this formula:

SELECT MAX(Record) FROM (VALUES ([@field:field1]),([@field:Field2]),([@field:Field3]),([@field:Field4])) AS NewValue(Record)

This formula works through your submission form with the newly inserted table.

 

 

[SunakoChan]

Hi @taylorswiftlover,

You may check this links regarding the MAX function:
- https://www.google.com/search?q=max+sql+function&rlz=1C1GCEJ_enPH824PH824&oq=MAx+sql&aqs=chrome.1.0l6.3687j0j7&sourceid=chrome&ie=UTF-8
- https://www.w3schools.com/sql/sql_min_max.asp

I hope those links will be helpful.