Offset issue for Fiscal Year Quarter

[former_member351149]

Dear All,

There is a requirement to develop a report for balance sheet to compare the fiscal year quarter like if user is going to give input 20143 then comparison quarter is 20142 where I did offset (-1) and if user give input as 20141 then the comparison quarter is 20134 where I am using offset as (-7).

So I have incorporated both offset in one variable. Now the issue is if I will run for any quarter then it is giving error in the run time. Could anyone suggest that how I could achieve this, whether I have used correct offset interval?

Query Key Figures Selections:

Bex Analyzer Selection Error:

Regards,

Abhishek Jain

[Loed · Accepted solution]

Hi Abhishek,

If you want to compare two (2) periods, you must create two (2) selections..

What do you really want to achieve? Can you post sample report?

Regards,

Loed