Minimum function

Wed, 08 May 2013 11:31:13 GMT

Hi all

I am trying hard to figure out a way for this. Kindly help.

I have the following table after doing some work on the base data.

I want to add one column "Classification", which would give

"L1" if the Sum column for a given Place is the MINIMUM among the available options.

"L2" if the Sum column for a given Place is the 2nd MINIMUM and so on.

I have showed the example for 2 Places.

Something like this.

Thanks in advance.

Re: Minimum function

Gysbert_Wassenaar — Wed, 08 May 2013 11:52:42 GMT

See attached qvw.

Thu, 16 May 2013 11:50:25 GMT

Thanks a lot Gysbert.

Just wanted to check if there is any way this could be done in the script.

Would be very helpful if a separate listbox could be made.

Thanks again