Skip to Content
0
Former Member
Oct 04, 2007 at 08:09 PM

Calculation of % on Date Differences - BW Reporting

37 Views

Hi Experts,

I have a typical scenario where in I need to calculate the % for the no of Days difference b/t 3 dates(Statistical Date, Delivery Date, GR Date).

As of now I just showed just the Difference b/t all the 3 dates in no of days. Now I need to acomplish the below task, Can any one plese suggest me how to proceed to resolve all the below conditions.

Need to provide the % of orders that fall into the following buckets for each of the above 3 Dates only in Reporting.

1. On time = +/- 5 days

2. Greater than 6-10 days late

3. 11-15 days late

4. Greater than 16 days late

5. 6-10 early

6. 11-15 days early

7. Greater than 16 days early

I need to do this at Query level only as I don't have authorization to create a new Calculated Key figures or Restricted KF.

Only I can do is play around with the New Selection or New Formula at Column area of designer, write some Macros or can access Exceptional reporting for above 3 DATE Char or Key Figure fields and do some math to accomplish.

Thanks,

Sam