Fiscal Year period

[kpradeep5610]

Hi ,

i have a fiscal year period field 

Fiscal Year Period

2019012

2020001

here i want to display the fiscal year period like 

2019012 - 2019 - Mar

2020001 - 2020 - Aprl

like this .

Please help me.

Regards,

Pradeep K

[Taoufiq_Zarra]

can you provide more detail ? 2019012 to 2019 - Mar ?

fiscal year start at 04/ ?

2019012 year 2019 12 month and what about 0 between 2019 and 12 ?

[Saravanan_Desingh]

What format is this? 2019012

Can you explain more?

[kpradeep5610]

Hi 

please find the below fiscal period table for current year.

JAN -2019010

FEB -2019011

MAR -2019012

APR -2020001

MAY -2020002

JUN -2020003

JUL -2020004

AUG -2020005

SEP -2020006

OCT -2020007

NOV -2020008

DEC -2020009

here  i have the data for 3 months which is 

2019012

2020001

2020002 

here i want to display 2019-Mar ,2020-Aprl, 2020- May 

i hope this will help you.

Regards,

Pradeep K

[H_Julian]

//for example Dimension FiscalNum = '2019010'

Use the following Logic

SourceTable:

Load

*

From Source

Calendar_Source:

Load

FiscalNum

FiscalYear&' - '&Monthname as PeriodName

*,

Monthname(Makedate(Year,Period,1)) as Monthname

;

Load

FiscalNum,

Num(Num#(left(FiscalNum,4))) as FiscalYear

Num(Num#(right(FiscalNum,2))) as FiscalPeriod

if(Num(Num#(right(FiscalNum,2)))>=4,Num(Num#(right(FiscalNum,2)))-3,Num(Num#(right(FiscalNum,2)))+9) as Period

if(Num(Num#(right(FiscalNum,2)))<=4,Num(Num#(left(FiscalNum,4)))+1,Num(Num#(left(FiscalNum,4)))) as Year

Resident

SourceTable

Left Join (SourceTable)

Load *

Resident Calendar_Source;

Drop Table Calendar_Source;