This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Finding the highest Value/Score from columns

Posted on 08-27-2022 04:49 AM
Uk
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Hi All,

How to find the highest Score from these columns?

say, in this table , it has:

Score A = 80

Score B = 79

Score C = 80

Any idea what is the formula how to know the highest score form the column above? thanks

ok.PNG

Solved Solved
0 4 292
Topic Labels
Jump to Solution
0 Likes
Reply
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 2
Platinum 2
Reply posted on --/--/---- --:-- AM

When computing within the same row, the columns will need to mentioned exclusively.

 MAX(LIST([Score A] ,  [Score B] ,  [Score C]))

will get the highest score.

View solution in original post

Jump to Solution
Reply
4 REPLIES 4
Top Labels in this Space