Percentages in List Report

[gatorfe]

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!

[Francis aka khayman]

How does the expected output look? And how is the computation derived?

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!