Hello, we have a customer that brought up a question regarding the way % are calculated on a simple list report. Attached is the output. The OTD% shows the correct values for the lines of Item Class 2A and 2B under the OTD% column. For Item Class 2A the OTD is calculated 90/94=95.7%. The 90 is from the On Time(O&E) column and the 94 from the Total column. For Item Class 2B the OTD is calculated 1/1=100%. The 1 is from the On Time(O&E) column and the other 1 from the Total column. When we divide the overall line values of 91/95 the report shows 97.9 instead of 95.8. 97.9% is correct if we were looking at the values of the OTD% column but the user is looking at it from a line level. Any suggestion on how that can be changed to show the expected value? Thank you in advance for any feedback!
How does the expected output look? And how is the computation derived?
Quote from: gatorfe on 23 Sep 2014 01:52:52 PM
Hello, we have a customer that brought up a question regarding the way % are calculated on a simple list report. Attached is the output. The OTD% shows the correct values for the lines of Item Class 2A and 2B under the OTD% column. For Item Class 2A the OTD is calculated 90/94=95.7%. The 90 is from the On Time(O&E) column and the 94 from the Total column. For Item Class 2B the OTD is calculated 1/1=100%. The 1 is from the On Time(O&E) column and the other 1 from the Total column. When we divide the overall line values of 91/95 the report shows 97.9 instead of 95.8. 97.9% is correct if we were looking at the values of the OTD% column but the user is looking at it from a line level. Any suggestion on how that can be changed to show the expected value? Thank you in advance for any feedback!