Good day to All,
I having a problem in computing on a per month basis.
i have a table that has a Column name July to June
and I need to compute each month base on Posting Month, Start Date and End Date.
example
My PostMonth is 7/1/2012, My Start Date is 9/1/2011 and my End date is 8/1/2012
I need to compute an Actual Sales and Forecast Sales.
so i have a July column, this should be a Actual Volume and August this should be a Forecast volume.
need your help guys.