Page 1 of 1

Difficult problem- Formula values to change with drill down

PostPosted: Thu Oct 24, 2002 11:04 am
Hi ,
The value in the formula variable value needs to vary depending upon the months displayed. For example if the columns display january, february, march and april. The formula variable should be 1, 2, 3 and 4 respectively. ( 1 for january, 2 for february and so on...).
This view of report is normally a drill down on months of a year.
The current formula variable we use allows only one value to input before execution of query.
Variables with user exits also work the same way.

Any help, suggestions ??

Thanks in advance.


PostPosted: Fri Oct 25, 2002 3:12 pm
by Guest
could you tell me what kind of formula you are attempting to do? would a restricted key figure do the trick?


Dynamic Formula variables values

PostPosted: Mon Oct 28, 2002 3:30 am
Hi Guest,
Restricted key figures will not help because the formula values(number) will need to change depending on drill down for a range of months.

How about using virtual characteristics

PostPosted: Mon Oct 28, 2002 3:52 am

take a lock at the HOW-To Paper named

How to work around the "single key date" limitation for time dependent master data

You will have to adapt the paper to your needs, but the ways to do it stays the same...

If there should be any questions feel free to ask.