Formula Help: Percentage for contribution points

I am new-ish to Airtable. I am having an issue with creating a formula that give the correct output for contribution points acquired. I have a Total contribution points table, a points log table, And the master table with the contributors. I think I have the pieces in place but the category based formula is giving those with 1 point 100% and those with 2, 50% I am wondering if this is because along with a total count of all the points across all categories do I need to also collect the total points on another table of each individual category count? The current category count, counts only how many points a contributor has in that category. Secondarily, there is a weight to each category sor CAT 1 is 40%, CAT 2 is 40%, CAT 3 is 10%, CAT 4 is 10%. I hope this makes sense.