Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements


  • Give kudos
  • My kudos


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Getting jql results in the multiple of thausands

While running the jql query using issueFunction in aggregateExpression("Total points", "US.sum()") I am getting the results in the multiple of thausand like for the result 36, I am getting in Jira as 36000. I am gettig the correct result but with 000 at the end.

Does anyone have an idea for this behaviour.

Thanks in advance.

1 answer

0 votes
tom lister Community Leader Nov 21, 2018

Hi @kanishk Tandon

What is the field US defined as?

Sorry I forgot to mention its UserStory, so basically a query to sum up all the User story points of all User Story in an Epic.

tom lister Community Leader Nov 22, 2018

Hi Kanishk

Story about lack of response, my MacBook died on me and have been restoring it.

I tried this on my machine and I don't get the 000's error

Screenshot 2018-11-22 at 15.28.48.png

I check my db values for story points and they are just floats with expected value e.g. 5.00000

Nothing else to add I'm afraid.

No Problem Tom and thanks for your response.

Looks like some issue with Jira configuration but the query seems to be correct.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence Cloud

Share your Confluence Cloud experience for a chance to win $500!

Take our 5-minute survey to win a $500 Visa gift card! Are you currently using Confluence Cloud? We want to hear from you! Fill out this quick survey about your Confluence Cloud experience so we ...

139 views 1 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you