Former Member

# 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.

Thanks.

Bass

10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Nov 21, 2011 at 08:22 AM

Can you elaborate it? What does "if the current QuarterFY is less than the current QuarterFY" mean?

10|10000 characters needed characters exceeded
• Former Member Former Member

Dear Bass,

Your KFGs(actual and budget) will be put in the formulas and hide your KFGs.Then you will show your formula for budget in the right time(i.e in the future i.e when current date Year-Quarter).To achieve this in the formula, you must create if-then statement of course.So you need Boolean operators and you need to compare current date and Quarter-Year combination.

However, unfortunately this model does not work without 0calquarter.Because you can not compare the current date and Q1.You can only compare current date and Q1/2011 for example.So you need quarter and year not seperately but together.

Here is a similar problem with dynamic field selection: dynamic-field-selection-by-variable-input-in-bex-r .You will see something about Boolean Operators(for if-then part) and formula variables with replacement path(to use a variable in the formula) in this thread.

Regards,

Sunny