How to add Null+Value

[Neetu Verma]

I have 3 custom field which stores the estimation for 3 work categories.  They all are numeric fields.

Our Story point is the addition of all these 3 fields

I have this Math rule which works if 3 of these are valued

{{#=}} {{issue.customfield_12018}} + {{issue.customfield_12020}} + {{issue.customfield_12102}} {{/}}

But sometime not all 3 fields will be valued and then I get below error

Error rendering smart-values when executing this rule:Missing parameter(s) for operator +: + 0.25 +

Can someone help me to figure out how to handle Null

[John Funk · Accepted solution]

Hi Neetu - try this code which sets the value of the field to 0 first if it is missing a value:

{{#=}} {{issue.customfield_12018|0}} + {{issue.customfield_12020|0}} + {{issue.customfield_12102|0}} {{/}}

[Neetu Verma]

OMG.. John

Thank you so much.. it worked. I cant even thank you enough for making this work. I am super glad I didn't put a workaround. 

Thanks

Neetu

[John Funk]

Great! I am glad that worked for you.  :-)

Can you click on the Accept answer button above so we can close this one out? Thanks!

[Mustafa Slatewalla]

Awesome !! This worked Well !!

[Jeshua Paul]

This is exactly what I needed as well, thank you @John Funk !!! The "|0" is brilliant and will be really useful for number fields in the future !

[John Funk]

Great! Glad you found it useful.