Customer sort order doesn't work

[nicogene]

Dear all,

With list box object, the custom sort order doesn't work.

The formula used: Only({1} Match(Month,'01','02','03','04','05','06','07','08','09''10','11','12'))

And an example in attachment.

Many thanks in advance for your help.

Kindest regards,

Nicolas.

[Anonymous]

You just lost a comma between 9 and 10.

Try to insert it!

Elena

[Anonymous]

Hi,

Comma is missing between 09 and 10

Try:

Only({1} Match(Month,'01','02','03','04','05','06','07','08','09','10','11','12'))

[nicogene]

Thanks but the problem is still present.

Kindest regards,

Nicolas.

[Anonymous]

This sholud be correct (without 0)

Only({1} Match(Month,'1','2','3','4','5','6','7','8','9','10','11','12'))

[nicogene]

Thanks for your response.

It works but I don't understand why it doesn't work with 01, 02 etc.

Kindest regards,

Nicolas.

[Anonymous · Accepted solution]

Because your field Month have values without 0 and for this reason match function didn't work.

Elena

[nicogene]

Ok thanks for your time.

Kindest regards,

Nicolas.

[MarcoWedel]

Hi,

another solution could be to replace the line

    [Month Name],

in the load statement of your sales table with

Month(Date#([Month Name],'MMM')) as [Month Name],

to use numerical sorting instead and to forget about sorting expressions.

To get the same month names as before, you may have to redefine your MonthNames variable as well.

hope this helps

regards

Marco