Value before Min Value

[Anonymous]

Hi

I have a list box with values in text , I need to display the value before minimum value , by usng minstring(column) I get the minimum value sorted alphabetically how do I get the value before that?

Thanks

[avinashelite]

try like this

min(column, 2) this will give the 2 min value of your column

[Anonymous]

it is a string so I have to use minstring right? with min I am not getting values

[kaushiknsolanki]

Hi,

You can try this.

=MinString({<Name -= {"$(=Minstring(Name))"}>}Name)

Regards,

Kaushik Solanki

[Anonymous]

This gives me a value but not picking the 1 value before minstring ..but 4 values before the minstring value

[kaushiknsolanki]

Hi,

Can you share sample values. Also tell us what value you want as output.

Regards,

Kaushik Solanki

[avinashelite]

please share the sample data ??

[Digvijay_Singh]

confusing, as nothing can be before minstring, I thought you wanted next minimum value which can be generated using Kaushik.solanki expression. Please elaborate further the req.

[Anonymous]

With Kaushik's expression I get the value underlined in Red , I am looking for Yellow highlighted value , I guess the values being case sensitive is causing issue

[kaushiknsolanki]

Hi,

This is because the way minimum string is found is it gets converted into ASCII values and then as per the ASCII values the function gives you the minimum String.

If you look that way then the minimum string is AgentServiceCenter and then within that the Minimum will be AgentServiceCenter:M...... Because in ASCII table Capital latter have minimum ASCII values.

Regards,

Kaushik Solanki