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!

[Babar khan]

To calculate a GWA in Jira Cloud—similar to how an ATAR calculator works—you simply create fields for each subject’s grade and credit hours (weight), then use automation to multiply each grade by its weight, add all those results together, and divide by the total of the weights using the standard formula GWA=∑(grade×weight)∑weightGWA this approach lets the system automatically compute the weighted average, and for a cleaner setup you can also use subtasks for each subject so the values are combined and calculated more easily

[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