I have many assignments in one category (homework, classes, and quizzes).  These assignments vary in the amount of points that they are worth.  I like to display the grades as percentages so that it's clear to students what grade they are getting.  Unfortunately, Canvas calculates the averages in a category using the point value of an assignment and not the displayed percentage.  I used to do my grades in Excel and in Excel, the averages were calculated based on the displayed average (not the underlying point value)

I asked Canvas for help, and the representative told me to make sure that all assignments had the same point value.  That is not a good fix.  An assignment with fewer points should not be valued less than an assignments with a greater number of points.  There are so many assignments throughout the semester and if each assignment in a category should have equal weight.  

Please tell me how I can re-configure my Canvas gradebook so that averages are calculated based on displayed averages and not the underlying denominators.