Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
how to pick up max value from 4 different fields by comparing them with each other
i want to pick up value from this field which is maximum
field | field 2 | field 3 | field 4 |
---|---|---|---|
100 | 200 | 50 | 60 |
70 | 20 | 60 | 90 |
Hi
I reckon you should remove TOTAL to get the max for each line
max(RangeMax(f1,f2,f3,f4))
Chris
In a chart?
max(TOTAL RangeMax(f1,f2,f3,f4))
Hi
I reckon you should remove TOTAL to get the max for each line
max(RangeMax(f1,f2,f3,f4))
Chris
Yes if he wants the max at row level
and rangemax works in script too
load
d,f1,f2,f3,f4,RangeMax(f1,f2,f3,f4);
LOAD * INLINE [
d,f1,f2,f3,f4
a,100, 200, 50, 60
b,70, 20, 60, 90
];
Thanks for your replay
For easy Way to solve this
before this i have done it by using if
but your way is easy way to it
Hi,
Christen in above Example suppose that i want field name not field value after comparison
how can i do that