find the maximum value across field

[sivarajs]

Hi,

i have 4 fields and i need to get field having maximum value

eg;

fieldname1 - 12

fieldname2 - 24

fieldname3 - 09

fieldname4 - 06

fieldname2 has the maximum value and i need to get this field either in script or in chart

Thanks

Sivaraj S

[Sokkorn]

Hi Sivaraj S,

Can you provide a sample data source with row and column and the result you looking for?

Regards,

Sokkorn

[sivarajs]

see the xls i explained what i want

[#4]

if(f1>f2 and f1>f3 and f1>f4, 'f1',

  if(f2>f1 and f2>f3 and f2>f4, 'f2',

   if(f3>f1 and f3>f2 and f3>f4, 'f3',

    if(f4>f1 and f4>f2 and f4>f3, 'f4'

         )

        )

        )

       ) as MaxFiled

[sivarajs]

thanks for the solution its good i have already tried that .If we have some 3 or 4 fields then its ok but it should be generic

any idea