Dual fiscalmonth challenge

[marcel_olmo]

Hi guys,

I'm trying to make a fiscal calendar and I'm having an issue with the dual() function.

My fiscal calendar has 2 exercises :

• 15 / 16 : From may15 to march16
• 16 / 17 : From april16 to march17

When I build the FiscalCalendar table I use the function dual to order the fiscal months like this :

Dual(Month, PeriodNum)

as FiscalMonth,

But the first month of Exercise 15/16 is may and the first month of Exercise 16/17 is april. So this is my undesired result :

How should I do it to get the fiscalmonth as april instead of may?

I've attached what I'm doing if someone can help me.

Regards, Marcel.

[marcus_sommer]

If you creates a fiscal calendar like in this example: Fiscal Year you didn't need mandatory a separate dual-sorting but you will need an additionally logic (probably with a small if-loop) to catch your uneven fiscal year.

- Marcus

[marcel_olmo]

Thanks Marcus for answering. In fact my fiscalcalendar runs with the logic of that post. I'm trying to do the logic with no success

[marcus_sommer]

I think I would create the PeriodNum (within the last load or more probably I wouldn't split the calendar and have only one single load respectively preceeding-chain) per autonumber(FiscalYearMonth).

- Marcus