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; } } }

Errors on my automation calculation

Claas Babendererde

We've got some numeric values, and I wanted to create a automation calculation to come up with a final "total score".

1st I set triggers (I think they are not so important here)

2nd I added smart-value-variable {{total score}} (does not know if that is actually necessary, since the field "total score" already exists)

3rd variable creation ("total score" field value).

{{#=}}{{issue.customfield_10091}}{{/}}{{issue.customfield_10090}}{{*}}{{issue.customfield_10081}}{{*}}{{issue.customfield_10092/100}}

Anyone got feedback to this calculation which leads to the error EINIGE FEHLER (some errors/non specified)?

Accepted answers

John Funk

Hi Claas,

Try this:

{{#=}}{{issue.customfield_10091}} / {{issue.customfield_10090}} * {{issue.customfield_10081}} * {{issue.customfield_10092}} /100{{/}}

If that's what you are trying to do. That will divide the first number by the second number THEN multiply that answer by the third number THEN multiply that answer by the fourth number. Finally, that answer will be divided by 100.

I don't think that's what you want to happen, but maybe it is.

All comments

Valerie Knapp_dpp5c6

Hi @Claas Babendererde , thanks for your question.

If you aren't getting a clear reason for why the automation isn't working, I typically also add an action putting the same calculation into the audit log -

You could also put different variations of the calculation in here, to see how far you get before it fails for example.

{{#=}}{{issue.customfield_10091}}{{/}}{{issue.customfield_10090}}{{*}}{{issue.customfield_10081}}{{*}}{{issue.customfield_10092/100}}

and so on. Have you already tried something like this? What was the result?

Claas Babendererde

Thx so much for your suggestion.

I did not get the reporter thing working nor did I understand how it could help me. But I tried to ease the calculation.

You need at least {{#=}}{{issue.customfield_10091}}{{/}}{{issue.customfield_10090}}

It works!

Adding

It works!

Hence the issue is the expression {{issue.customfield_10092/100}}

What I wanted to do:

(A/B*C)*(D/100)

I replaced to

{{#=}}{{issue.customfield_10091}}{{/}}{{issue.customfield_10090}}{{*}}{{issue.customfield_10081}}{{*}}{{issue.customfield_10092}}

(left out division by 100) and it works.

Still I get a error code (translated by deepl)

Edit operation
Could not convert the field value to a number. Please ensure that the value is a number, a mathematical expression or a smart value that can be converted to a number.
Total Score: 1362.037.51736.0
No fields or field values to edit tasks (possibly due to field values not being present in a particular project):

This is astonishing, since there are only complete numeric values except mrr, which can be like 1240.24 (always two values post .)

John Funk

Hi Claas,

Try this:

{{#=}}{{issue.customfield_10091}} / {{issue.customfield_10090}} * {{issue.customfield_10081}} * {{issue.customfield_10092}} /100{{/}}

I don't think that's what you want to happen, but maybe it is.

Claas Babendererde

@John Funk
Unknown unary operator * at character position 14: 3.0 / 6.0 * * 1139.0 /100

I think that you always need to {{}} operators, at least this is what I learned from the automation resource board.

I tried to rephrase yours but
/100 {{/}}
as well as
{{/100}}
as well as
{{/100}}{{/}}

result in

Error when processing the template: Mismatched start/end tags: null != 100 in template-95e3eadf-682e-4895-a61f-8beaf8244d5d:1,

so I cannot even publish the automation.

I just need an idea now on how to dived the whole calculation by 100 and how to avoid

"Could not convert the field value to a number. Please ensure that the value is a number, a mathematical expression or a smart value that can be converted to a number.
Total Score: 1362.037.51736.0
No fields or field values to edit tasks (possibly due to field values not being present in a particular project):"
(See post below answering @Valerie Knapp )

John Funk

What exactly are you trying to calculate?

Claas Babendererde

@John Funk

(Votes/Views) * ((TotalMRR*(FoxlyScore/100))

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

automation

calculation

smart-value