Question:
I need to create a report where the user can enter two time periods in order to compare data (they can be any time periods, such as 06/2002 and 08/2003). I have created two variables based on 0CALMONTH to capture this data.
Then I need to determine the number of days in each of the time periods in order to create an average for that month.
Report looks like this:
----------------------- 06/2002 ---------------------08/2003
Plant1--------------Total Qty/30 --------------- Total Qty/31
Plant2---------------Total Qty/30 -----------------Total Qty/31
I created two variables of type Customer exit (Numdays1 and Numdays2).
Using the example above, with time periods of June and August, how do I fill Numdays1 with the value 30 and Numdays2 with the value of 31?
Does anyone have any ideas that might help? If so, please let me know as this is rather urgent.
Thanks a lot.
Answer:
Create 2 formula variables which are filled in by a customer exit. In the customer exit, you browse the content of the related period variable, and calculates the number of days ...
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.