nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

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

All comments

Trudy P 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:

Print each of the custom field values to the rule Audit Log
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:

Screen images showing the entire rule
Details of the step where you are using the formula
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.

Screenshot 2024-12-04 133217.png

Trudy P Claspill

Thank you for that additional information.

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

Print each of the custom field values to the rule Audit Log
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:

Screen images showing the entire rule
Details of the step where you are using the formula
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

Verma, Shivam

Hi Bill, Thanks a lot this expression worked and in future i will try to give a detailed description with screenshots.

Regards,

Shivam

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

custom-field

jira

cloud

jira-cloud

smart-value

jira-automation

cloud-automation