Fiscal year selection(Set Analysis)

[ajaysingh29]

Hi All,

Need your help, I have data in which I want to display Fiscal year  data based up on selection.

If I select 2016 It should display data from Oct'15-Sep'16, if 2015 selected from Oct'14-Sep'15..same for 2017....

Thank you in advance.

[MK_QSL]

Use below link to create Fiscal Year and Fiscal Month..

Fiscal Year‌

Fiscal and Standard Calendar generation

[ajaysingh29]

Manish, thanks for your reply, can you please help me out with this code, I don’t have any date field & master calendar in app. It’s just year & month fields,with reference to Fiscal Year document I tried like this in code:

Set vFM = 10 ;

LOAD  Year,

Month,

dual(Year-1&'/'&Year,Year)as Fyear,

dual(Month,Month) as Fmonth,

Year+if(Month>='$(VFM)',1,0) as fYear,

Mod(Month-'$(vFM)',12)+1 as fmonth,

     Field1,

     Field2,

     Field3,

     Field4

FROM

.....

output is:

Many thanks. !