Hi, not able to get a correct answer using smart values

[Verma_ Shivam]

i have created a rule to create schedule variance in Jira automation, the rule is executing perfectly but the answer is still 0.

i am using this formula, 

{{issue.customfield_12425.diff(issue.customfield_11025).days.divide(issue.customfield_11025.diff(issue.customfield_11024).days)}}

please let me know where i am wrong.

[Trudy Claspill]

Hello @Verma_ Shivam 

Welcome to the Atlassian community.

What are the field types of each of the custom fields in that formula?

I recommend that you use that the Log action in the rule to:

1. Print each of the custom field values to the rule Audit Log
2. Print portions of the calculation, such as the result of the first diff() function, and the result of the second diff() function

Printing the values with the Log action will enable you to review the values to see if they match your expectations.

If that doesn't reveal the problem to you then please provide the following:

1. Screen images showing the entire rule
2. Details of the step where you are using the formula
3. The rule Audit Log output.

[Verma_ Shivam]

Hi Trudy,

All these custom fields are date picker field, i am trying to get value for (Actual End Date - Planned End Date)/(Planned End Date - Planned Start Date)

i am trying to capture the output of this formula in another custom field "Schedule Variance" which is a number field.

[Trudy Claspill]

Thank you for that additional information.

I recommend that you use the Log action in the rule to:

1. Print each of the custom field values to the rule Audit Log
2. Print portions of the calculation, such as the result of the first diff() function, and the result of the second diff() function

Printing the values with the Log action will enable you to review the values to see if they match your expectations.

If that doesn't reveal the problem to you then please provide the following:

1. Screen images showing the entire rule
2. Details of the step where you are using the formula
3. The rule Audit Log output.

[Bill Sheboy]

Hi @Verma_ Shivam -- Welcome to the Atlassian Community!

As Trudy describes, context is important for automation rule questions, so please include images of your complete rule, the audit log details, and explain the problem you are trying to solve. 

For such types of rules, it also helps to use the Log action to write intermediate results and smart values to the audit to check the values are what is expected.

Until we see that information...

You describe "the answer is still 0", and that is certainly possible for the expression you show.

• When using the date / time diff() function, the results is always an integer value
• The inline-line type of smart value, math expressions preserve the type usually
• When you diff().days that would be an integer
• Finally, when the division occurs, that would also be an integer, probably truncating down to 0

To get a fractional value, a math expression may be used.  For example:

{{#=}} {{issue.customfield_12425.diff(issue.customfield_11025).days}} / {{issue.customfield_11025.diff(issue.customfield_11024).days}} {{/}}

If you wanted that to a specific number of significant digits, you could add the ROUND() function, for example to 2 significant digits:

{{#=}} ROUND( {{issue.customfield_12425.diff(issue.customfield_11025).days}} / {{issue.customfield_11025.diff(issue.customfield_11024).days}}, 2) {{/}}

Kind regards,
Bill