Custom Script Field to sum value those results in billion

[Amit Kumar Singh]

What should is use in place of double to calculate the value in billion.

import com.atlassian.jira.component.ComponentAccessor

import com.atlassian.jira.issue.history.ChangeItemBean

// Get values from 4 custom fields

Double val1 = makeNullZero(getCustomFieldValue('Field Name ($)'));

Double val1 = makeNullZero(getCustomFieldValue('Field Name ($)'));

Double val1 = makeNullZero(getCustomFieldValue('Field Name ($)'));

Double val1 = makeNullZero(getCustomFieldValue('Field Name ($)'));

Double sum = val1 + val2 + val3 + val4;

[Mohamed Benziane · Accepted solution]

Hi @Amit Kumar Singh 

Can you try Biginteger or long

[Amit Kumar Singh]

Hi @Mohamed Benziane 

I tried long and it is working fine for me.. Thank You So Much!

[Mohamed Benziane]

hi @Amit Kumar Singh 

feel free to accept the answer to mark your question as solved

[Amit Kumar Singh]

Hi @Mohamed Benziane 

Need one more help on this as when i apply filter search, it shows below error.

[Mohamed Benziane]

It seems that your field "Total Annual" is a text customfield so you can't use the operator here