JQL to get the sum of total Story points in a project

[Bhushan Naga _ CONT-Type1-THUNDERSOFT INDIA PRIVATE LIMITED _]

Hi Team,
Please help me with sum of total story points in a project in jira cloud.
Previously I used the below expression when scriptrunner was available and I have Scriptrunner Enhanced Search now.
issueFunction in aggregateExpression("Total Points", "storypoints.sum()")

Appreciate your help!!!

Thanks

[John Funk · Accepted solution]

Hi Bhushan,

Take a look at this article and see if it helps you. You can roll those amounts up to a parent work item such as an Epic. 

[Bhushan Naga _ CONT-Type1-THUNDERSOFT INDIA PRIVATE LIMITED _]

Hi @John Funk 

Can I have the article link

[John Funk]

DOH! Forgot to add that. Sorry. 

https://community.atlassian.com/t5/Jira-articles/How-Can-I-Sum-Up-Multiple-Issues-into-a-Parent-Number-Field/ba-p/2882712

[Duc Thang TRAN]

Hello @Bhushan Naga _ CONT-Type1-THUNDERSOFT INDIA PRIVATE LIMITED _ 

I often used ScriptRunner on Data Center with math expressions. However, in ScriptRunner Cloud, I don't see that option available in Scriptrunner Enhanced Search.
So I believe it's not possible to calculate the sum directly via JQL, since math expressions aren't supported on cloud 
An alternative might be to export via Excel for Jira Cloud, with colum, 'Story Points' column and perform the calculation in Excel.

Hope this can help :)

[Evgenii]

Hi, @Bhushan Naga _ CONT-Type1-THUNDERSOFT INDIA PRIVATE LIMITED _ 

JQL is designed to work with issues and returns a list of issues as results. Field values are used only to filter and narrow down the query — to make it more specific.

This means that JQL won't return just a number of Story Points directly. However, you can create a query to find all issues in a project that have Story Points assigned, and then manually or via a gadget/dashboard, sum them up. Example of JQL:

project = TEST AND "Story Points" IS NOT EMPTY