Skip to Content
0
Apr 17, 2015 at 06:34 AM

Offset issue for Fiscal Year Quarter

229 Views

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

Attachments

pastedImage_3.png (14.3 kB)