How can I build a GWA calculator in Confluence or Jira to compute weighted average scores?

[Adnan Raouf]

Hi everyone! 👋
I’m trying to create a GWA (Grade Weighted Average) calculator using Confluence / Jira (Cloud) tools. I want users to input multiple numeric scores (e.g., subject grades and credit hours) and have the system automatically calculate the weighted average (GWA).

Here’s what I need help with:

1. Input fields for scores & weights (e.g., Grade and Credit Hours).

2. A formula or automation to calculate:
   GWA = (sum of (grade × weight)) ÷ (sum of weights).

3. Best approach using Confluence Database / Jira custom fields / Automation / Formula Fields.

4. Any examples, formulas, or steps you recommend for this setup.

I’ve looked at built-in calculation options and tried some suggestions, but I’m unsure how to structure the fields and formula correctly. Any guidance, screenshots, or community examples would be super helpful! 🙏

Thanks! 😊

[Nikola Perisic]

Hi @Adnan Raouf 

Best approach is with the automation rule and you would need to have three custom fields.

Example:

{{#=}} {{issue.Confidence}} * {{issue.Ease}} {{/}}

Replace the Confidence and Ease values with your needed values and do the calculation just like you have wrote.

https://community.atlassian.com/forums/Jira-questions/Calculated-field-in-the-cloud/qaq-p/2224242