Skip to Content
Former Member
Nov 20, 2011 at 12:53 PM

Fiscal Year in the columns outside KF structure


Dear Experts,

I have a manual Entry variable for Fiscal Year range.

In the query designer columns , I have a KF structure containing quarter level columns.

The FY is outside this structure. So, for each FY user entered in the FY range variable, the report will show the set of KFs at quarter level.

How can i refer to this FY values at runtime such that current date can be used to compare with the FY and Quarter in the columns?

The requirement is, if the current QuarterFY is less than the current QuarterFY, the TEXT variable for the columns should show 'Actual' else show 'Plan' .

I am not sure how to reference the FY range entered by user considering that the FY is placed outside the KF columns to automatically display all the FY entered by the user without the use of the FY range variable restricted in the KFs.

Please advise.