Based on From and To Date how to Calcuate PYTD/PMTD in WEBI 3.1
Please suggest me how to create a Formula which I can able to access Previous Years and Month Data In the report.
Report Parameters are like bellow:
Start Date: 01/01/2010
End Date: 07/09/2010
1. Requirement are like below.
a. Eliminate Weekends and Holidays
b. Calculate YTD and PYTD/PMTD based on current Year Date Range mention above
c. Once calculate YTD and PYTD then need to eliminate out of office hours (Ex: 5pm to 8am it will be 16hrs)
d. Now we get Total Number of Hours need to Convert into Days
e. Units Sold for YTD and PYTD need to Divide to take average for each units sold.
St Date: 01/01/2010
Ed Date: 20/01/2010
Take of Holidays and Weekends: For instance I take off 7 days
Total Days After eliminating weekends and Holidays would be: 14 days it include 20th day
Now Time to Calculate working hours for this 14 days.
Units Sold: 100 in 14days with working hours.
Again calculate avg.hours or days for each unit sold.
Finally calculate YTD and PYTD Calculation.
Please suggest me guys.