Skip to Content
0
Former Member
Dec 31, 2007 at 04:16 PM

urgent YTD Calculation

34 Views

Hi All

I am creating a report with the following format.

<chars..> , 0Calyear , Jan, Feb, ...., Dec, YTD

ABC......., 2004, 570, 240,....,300, 1500

ABC......., 2005, 200, 300, ...., 900, 2000

DEF......., 2004, 150, 200,.....,300, 2200

.....

.....

Results ........................

I have made the Jan, Feb, march as selections with hardcoded months and the YTD is based upon a user exit variable which restricts the selection from Jan to currnet month.

Nows the user wants to have the range of month in the selection screen wherein he should be able to specify the range of the months like from Jan to Aug.

Now my problem is when I try to make the months dynamic by placing Calmonth in the columns and restricting by a variable I am not able to calculate YTD there. Can you please suggest how to include the YTD along with the months as selection. Please help

Thanks

Randy