SunakoChan Posted February 12, 2022 Report Share Posted February 12, 2022 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 Quote Link to comment Share on other sites More sharing options...
0 telly Posted February 12, 2022 Report Share Posted February 12, 2022 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/ Quote Link to comment Share on other sites More sharing options...
Question
SunakoChan
Hi Team,
![image.png.e08e294408f773745eb5f56a37633b58.png](//content.invisioncic.com/r269793/monthly_2022_02/image.png.e08e294408f773745eb5f56a37633b58.png)
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
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.