Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try setting the sort order to this:
=Only({1} FisMo)
HI Sunny,
This helped me.
Thanks and Regards
Mahesh Gadde