Function fix the order value

[Black_Hole]

Hello all,

I would  like to display the value ranked in ascending order in my "Period" list box.

Because,  in my current list box, the order depend on the availability of the value in the table like below:

What function can I add in my expression in order to avoid this mess in my list box?

Thank you in advance for your help.

[sultanam · Accepted solution]

Hi,

You need to deselect the 'State' in Sort properties of list box and just select the Numeric Value Ascending in Period list box.
PFA

Regards,
Sultan

[Black_Hole]

Hello @sultanam ,

Thank you very much for your help.

I try it and now my value are correctly ranked. 👍