How to create weighted percentage average with grouped fields?

Hi,

I have this view for my OKR: (https://)ibb(dot)co/(rwf7SqV) (Sorry it seems that I can’t add a link to a post, so you need to remove the extra “()” and replace the (dot) by a “.”)

I’ve added a “completion weighted” column with this formula {Completion (fill)} * Weight so I can use it to calculate a weighted percentage average in other tabs. It works well except when I grouped fields. As you can see on the screenshot, the average calculated automatically by Airtable when I grouped fields is wrong and it seems that I can’t use a formula here. I can only choose between some functions like average, count etc. Is there a way I can calculate my weighted percentage average with grouped fields?

I hope my explanation is clear enough. Let me know if not.

Thanks!

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.