Find out Highest value from list

[valishaik1985]

Hi Team,

My Data would be like below

ProductNo,BRAND,Week1,Week2,Week3,Week4,Week5,Week6,Week7
TV-20220428,TV_YELLOW,39,18,13,29,16,11,60
TV-20220428,TV_RED,09,22,13,22,12,1,13
TV-20220428,TV_BLUE,50,12,08,12,17,16,10

Expected Output Would be like below

 ProductNo, COLOR, Highest Sales
 TV-20220428, YELLOW, 60
 TV-20220428, RED, 22
 TV-20220428,BLUE,50

This should be do frontend only

Thank You.

Regards,

ValiShaik

[Aurelien_Martinez · Accepted solution]

Hi,

If you want only in the front, you can use  RangeMax(), like : 

RangeMax(Week1, Week2, Week3, Week4, Week5, Week6, Week7)

For more reusability you can do on back end a crosstable and simply a Max().

Aurélien

[abdulgaffarskbi · Accepted solution]

Hi,

If you want only in the front, you can use  RangeMax(), like : 

use : Sum(RangeMax(Week1, Week2, Week3, Week4, Week5, Week6, Week7))

Regards,

Abdul

[valishaik1985]

Thank you for your reply, your solution also works perfectly.

In my case sum function also should use to fix issue.

Appreciate your feedback & respond quickly.

Thank You.

[Aurelien_Martinez]

If you have a lot of field beginning by Week (or what you want) and you don't want to list them, you can use:

RangeMax($(=Concat({<$Field={"Week*"}>} $Field, ', ')))