Sort order getting jumbled after selection in list box

[#1]

My Fiscal months are Nov-Oct

I use the following to calculate the month number of my Fiscal

Calendar:

LOAD

    D AS Link_Date,

    D AS Date,

//Fiscal Dates

     'Q' & Ceil(month(AddMonths(MonthsName(3,D,0,11),-10))/3)     as FisQuarter,

     num(month(AddMonths(MonthsName(1,D,0,11),-10)),'#0')     as FisMo,

    num(Year(AddMonths(MonthsName(1,D,0,11),+2)),'#0')         as FisYr,

    month(D)                                                             as FisMoShort,

When I create a list box that is a list of the fiscal month names (Nov, Dec, Jan .... etc), I set the sort order to Expression = FisMo and the months come out in the right order

When I make a month selection, the months get jumbled.   Any ideas?

[sunny_talwar · Accepted solution]

Try setting the sort order to this:

=Only({1} FisMo)

[gaddeonline]

HI Sunny,

This helped me.

Thanks and Regards

Mahesh Gadde