Running Top 100 vendors report from menu Accounts payable | Inquiries and reports | Vendor reports, options number of records=100, sorting=Revenue ends with generating a report with incorrect percentage for each vendor and also sometimes the total of percentage is either lower or greater than 100%.
The total amount based on which the percentage is calculated is always the total amount for all suppliers with transactions. When the number of records from user input parameter is equal or greater than maximum number of suppliers with records, then the percent is correctly calculated. Else, the percentage is incorrectly calculated.
The request is to fix the design for the report to calculate percentage for each vendor for the number of records from user input parameter and total percentage always to be 100.