Getting jql results in the multiple of thausands

[kanishk Tandon]

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.

[tom lister]

Hi @kanishk Tandon

What is the field US defined as?

[kanishk Tandon]

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]

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

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.

[kanishk Tandon]

No Problem Tom and thanks for your response.

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