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 |
