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! 😊

[Joseph McComas]

Hi Adnan!

You can set up numeric fields for Grades and Credit Hours in Jira or Confluence. Then calculate GWA using this formula:

GWA = (sum of (Grade × Credit Hours)) ÷ (sum of Credit Hours)

• In Jira, use Automation + Smart Values to update a custom field with this calculation.
• In Confluence, use a table + calculation macro (like Table Transformer) for automatic results.

To test or use a ready-made calculator, check GWA Calculator just enter your grades and credits, and it calculates your GWA instantly.

Hope this helps!

[Carolina Santoss]

If you're calculating GWA across multiple subjects using sub-tasks per subject, you can compute it at the parent issue level using Automation.

The formula is:

GWA = Sum of Grade × Credit Hours ÷ Sum of Credit Hours

For Jira Automation, the smart value approach would be:

Sum all Weighted Score from sub-tasks

Divide by sum of all Credit Hours from sub-tasks

Example in simple text:

GWA = sum of subtask Weighted Score ÷ sum of subtask Credit Hours

Make sure all fields are numeric Number type, otherwise the calculation won’t work correctly. This calculation logic is similar to how a date calculator aggregates inputs to compute a final result the key is structuring your fields consistently.

[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