Question:
We require two types of output on our report line:
Sum of P1 to Px, PX+1, PX+2, PX+...
X is determined by an input variable.
The PX and PX+1, etc are easy to get.
The sum of P1 to PX is harder.
What is the preferred method to obtain?
Answer:
What are P1 ... to PX ? Periods ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
P would be data for a period.
Answer:
Any thoughts?
Answer:
cud u provide some more information. state the problem clearly and what steps u did till now? some one might get anyidea. thanks.
Answer:
Column 1 can be a restricted key figure, with the time period restricted via 'Value range' >= P1 and 'Value range' <=Px.
Each additilnal column is a restricted key figure, with the time period restricted by only the Px variable value, using variable offsets where appropriate.
Answer:
Hi N8IVNYER
Sorry for a delayed reply, was out of circulation a bit.
I take it that P1 in your example is a semi fixed period, something like the first period on the current year.
If that is the case, a user exit variable would be your best bet.
Have a look, there are a few posts where i gave examples of this type of code on this board.
If the period P1 is always the same, eg it is always 01.2000 then you can just hardcode it in your restriction on column 1. but this seems rather inflexible as you will have to change this restriction every time the year changes is the case where column 1 is something like a year to date value.
cheers
Answer:
What are steps to restrict to "less than or equal to" the selected FISCPER?
Know this was in the forum previously but cannot find the explanation.
Thanks . .