Exit for all periods of a Fiscal Year
For a query we have the following scenario:
1. User Input variable on 0FISCYEAR: 2009
2. I want to create a restricted key figure (RKF) which cumulates the value of a Key Figure for the previous year
Is this something that I can do via offsetting.
In my RKF use 0FISCYEAR and offset by -1. I do not have access to a system at present when offsetting are we offsetting at the variable level or object? Thanks
Purvang Zinzuwadia replied
no, you need not create another variable, just use the same variable,
When you restrict the values using the variable, right click on it, it will show you option for OFFSET VALUE, select offset value and give -1. so it will automatically calculate the previous year's value.
hope this helps,