Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi GUys,
I have one fiscal year like 2012,2013 = Calendar year 2012
2013,2014 = Calendar year 2013
2014,2015 = Calendar year 2014
2015,2016 = Calendar year 2015
I want the fiscal year to be shown like 2012 for 2012 ,2013
and 2013 for 2013,2014
i want it dynamic, if new year comes than this process automate and give me next year.
how i can do this?
i think it can be done by loop, any suggestion?
Maybe like
LOAD
Subfield( [Fiscal Year], ',',1) as [Fiscal Year],
...
Date#(SubField('2012,2013',',',1),'YYYY') as FiscalYear
not working
i want to represent fiscal year as my calendar year..
by above getting same output
How your Fiscal Year field is and how you want to show !
I think i miscommunicated .. sorry for that,
i have fiscal year like below
2012
2013
2014
2015
2016
and calendar year
so when i m selecting 2012 calendar year, fiscal year 2012 and 2013 highlighted. so i want to show this fiscal year as single field having value as calendar year which is 2012.
my customer too has a fiscal year whicjh differs from calendar year
I provided a mastercalender with additional fields for fiscal year, fiscalmonth etc.
so January 2016 is fiscal year 2015 with fiscal month nr 10
are they in single table or different table?
yes they are in single table
can you provide some sample data with 4-5 lines...?
