How to get string column value based on two column Max of value (Expression)

[muniyandi]

Hi Team,

i want to get Mac_Code column  value based on max of value of two column (VAL1,VAL2) in Text box expression.

Condition: first we have to consider VAL1 column Max of value then VAL2 column max of value.

Expecting Result is Mac_Code Value = E.

i have tried using FirstSortedOrder function some case max of value in VAL1 column repeated the same value ,this case i'm getting NULL.

Sample Data:

Mac_Code	VAL1	VAL2
A	79	4300
B	45	4800
C	100	3800
D	99.91	4000
E	100	4100
F	89	5000
G	99.1	2300
H	97	1020
I	100	3950
J	95.34	2500
K	100	2700

[muniyandi]

any updates guys...