how to pick up max value from 4 different fields ..

[#1]

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

[maxgro]

In a chart?

max(TOTAL RangeMax(f1,f2,f3,f4))

[#3 · Accepted solution]

Hi

I reckon you should remove TOTAL to get the max for each line

max(RangeMax(f1,f2,f3,f4))

Chris

[maxgro]

Yes if  he wants the max at row level

[maxgro]

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

];

[#6]

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

[#7]

Hi,

Christen in above Example  suppose that i want field name not field value after comparison

how can i do that