how to derive calmonth from number of days
My customer has the following requirement. They want a actual Vs Plan sales report,
with user input being the calmonth (Eg: 06/2010)
The format is as follows:
material | actual sales | Plan sales | material delivery (days) | plan calmonth
10 200 150 90 mar10
20 100 160 135 feb10
Here the plan sales should be restricted by calmonth, which should be calculated by deducting the number of material delivery days from the user input month. Eg: If the customer enters 06/2010 as the input, then the report should show actual sales for 06/2010, and plan sales for 'mar10' if the delivery days are 90 for material 10 (06/2010 - 90 days = 03/2010) and 'feb10' if the delivery days are 135 (06/2010 - 135 = 02/2010) for material 20.
Can you please help me out in arriving at the solution for this.
Thanks & Regards,
Edited by: Ramana Kumar on Jun 24, 2010 3:00 PM