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.
Question
Formula Help: Percentage for contribution points
+22It’d be very helpful to see a couple screenshots of your base and formulas (with dummy data).
You’re missing a shared category total.
Right now Airtable is calculating:
individual points ÷ individual total → wrong result
You need:
- Total points per category (all contributors combined)
Then formula:
your category points ÷ category total × weight
Without that global category total, your percentages will stay skewed.
+1I think you are close. It sounds like you need the total points for each category across all contributors, not just each person's category total. That overall total should be used before applying the category weights. If you post your formula, the community can help pinpoint the exact fix.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.