topic Re: Find out Highest value from list in App Development

Find out Highest value from list

valishaik1985 — Thu, 11 Aug 2022 13:13:51 GMT

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

Re: Find out Highest value from list

Aurelien_Martinez — Thu, 11 Aug 2022 13:22:55 GMT

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

Re: Find out Highest value from list

abdulgaffarskbi — Thu, 11 Aug 2022 13:25:42 GMT

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

Re: Find out Highest value from list

valishaik1985 — Thu, 11 Aug 2022 13:31:23 GMT

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.

Re: Find out Highest value from list

Aurelien_Martinez — Thu, 11 Aug 2022 13:40:31 GMT

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, ', ')))