How to get the max value for multiple fields?

[SunakoChan]

Hi Team,

May I know possible to get the maximum value of multiple  fields?

For example: 



The expected results are:
ID     Max Value
1               4
2               4
3               41

[telly]

Hi @SunakoChan,

You can use SQL statement to get the maximum value for multiple fields:

SELECT MAX(Record) FROM (VALUES ([@field:N1]),([@field:N2]),([@field:N3]),([@field:N4])) AS NewValue (Record)

For reference you may check this link: https://howto.caspio.com/function-reference/