Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregate value doesnt use decimals from custom fields

Mait Mandel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 26, 2017

I have custom fields that have numerical data as values (also values that include decimals - 1.5 or 10.1 etc)

When doing an aggregation, the sum leaves out the decimal part:

1.5 + 10.9 = 11

 

It does work correctly on standard fields, though ...

 

Any ideas on what should i check or change?

Thanks

3 answers

0 votes
Mait Mandel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 27, 2017

How exactly do I control that?

When I create a new custom field, I just have the option to choose "Number Field" ...

Tarun Sapra
Community Champion
January 27, 2017

Put the (Double) type casting where the aggregation is taking place. which plugin are you using for this functionality?

0 votes
Tarun Sapra
Community Champion
January 26, 2017

If you are using script runner for, make sure you use "Double" type 

0 votes
Volodymyr Krupach
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 26, 2017

What do you mean b\y the aggregation? How do you do it? Some JavaScript or addon or in excel?

Suggest an answer

Log in or Sign up to answer