Skip to Content
0
Former Member
Jul 17, 2008 at 07:46 AM

Fiscal year period displaying previous years records tooo....

25 Views

Hi,

I have built a query, which displays all the metrics like Year to date(YTD) Actuals and Plan, Month to date (MTD) Actuals and Plan, YTD Variance, MTD Variance, Remaining Balance etc... The query uses a customer exit to calculate the above metrics.

Input filters are:

Company Code: single value, mandatory,

Fiscal Period: single value, mandatory

Along with other characteristics , Fiscal period is also provided in free characteristics.

Upon Execution (for eg:-) with input of fiscal period as 003/2008, the query displays the correct output for that year ie; 003/2008.

But when the Fiscal Period is dragged from Free characteristics to the columns fields, it displays all the metrics for all the previous years records too. ie; it displays the values of 003/2007 along with 003/2008. The client does not want this to happen. It should display the values only for the period given as input.

The client wants the fiscal period be provided in the free characteristics and not to remove it.

Can anyone advise what could be done to prevent the query from displaying results of previous dates.

Thanks in advance.

Maddy