Hi,
We have created an input ready query which displays sales and revenue per fiscal year/period. The fiscal year period is an interval of type customer exit which reads a table of start date and end date, maintained by the finance team, and then it uses a FM to transform into fiscal year/period. This interval is then used to determine which fiscal year/periods are displayed in the WAD.
I have a small problem with this interval however. The info object fiscal year/period 0FISCPER contains periods 00 13 14 15 and 16 for all years, which have no purpose for this input schedule - only periods 01-12 are needed. I need to exclude these periods from the interval selection, but this exclusion needs to be dynamic - so that it will count for all years in the future.or example, if the interval selection is fiscal year period 11.2016 - 04.2017 - the periods which are currently shown are:
11.2016
12.2016
13.2016
14.2016
15.2016
16.2016
00.2017
01.2017
02.2017
03.2017
04.2017
However we only want to show the following:
11.2016
12.2016
01.2017
02.2017
03.2017
04.2017
Does anyone know how to achieve this?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.