I have created a query which asks for a fiscal period variable. It shows account information for the wanted fiscal period and automatically brings the information for the fiscal period before it by using the offset -1 option. Along the year, it works right but in January it doesn't´t because of the K4 (16 periods) fiscal year variant.
For December, the right fiscal period to get is not 12. We use the K4 fiscal year variant, so in December the right period to retrieve is 16 (not 12).
In January the query is retrieving information for 2005.001 (variable asked to the user) and 2004.012 (offset -1). However we need the query shows the information for 2004.016. Is it possible to get this information not creating another query? I mean, is it possible to use the offset option (or any other option) in the same query to get the 2004.016 period instead the 2004.012 in January?
You will probably have to create a variable with a user exit to do this. In the user exit you can overwrite the variable with the right value.
Look the documentation up for what is required to set the user exit up.
hope that helps!
Rishi
Add a comment