Errors while using smart values to calculate totals when one of the value is 0

Valerie Blondel

Hi Team,

I am trying to calculate a risk score using a smart value.

This risk score is the multiplication of 4 different values.

Easy, except if one of the values is 0.

         

Here is the automation :

 

And here is my smart value calucation :

{{#=}} {{issue.Menace.value}} * {{issue.Vulnérabilité.value}} * {{issue.Impact.value}} * {{issue.Vraisemblance.value}} {{/}}

 

What could I do to prevent this ?  Is there a way I can ask Jira to "disregard" a field in which the value is 0  ?

 

Thanks beforehand !

 

Valérie

 

 

Najm Polaris

Hi @Valerie Blondel , 

anything multiplied by zero is always going to be zero. Your formula seems to be working perfectly. 

If you don't want to consider the zero than any field which is zero just change it to 1. This should serve your purpose. 

Just check if any of the 4 fields are 0 or not. If they are change them to 1. The rest should be same.