How Can I set value 0 if a Transition Count Field is Empty ?

ldogangul

My case is adding two custom fields and write it down on a third custom field.

My sum formula is: 

@Formula: ((issue.get("customfield_12107")) + (issue.get("customfield_12108"))) -->

where customfield_12107 is a transition count field.

 

If transtion count field is filled during transitions the formula works, but if transition count field is not filled (if its null)   the formula does not work. 

How my I set 0 value if the transition count field is NULL   ??

Any help will be appreciated.

Levent

David Fischer

You should always protect your formulas against null values:

@Formula: (issue.get("customfield_12107") == null ? 0 : issue.get("customfield_12107")) + (issue.get("customfield_12108") == null ? 0 : issue.get("customfield_12108")) -->