Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

calculation in automation

Tiziana Pisenti
Contributor
September 30, 2024 edited

I have the following automation:Automation_Lichtstrom.png Automation_Lichtstrom_step1.png Automation_Lichtstrom_step2.png

Automation_Lichtstrom_step3.png Automation_Lichtstrom_step5.png Automation_Lichtstrom_step6.png

Automation_Lichtstrom_step7.png Automation_Lichtstrom_step8.png

calculation aaRaumindex= ({{issue.customfield_10201}} * {{issue.customfield_10200}}) / (({{issue.customfield_10202}} - {{issue.customfield_10211}}) * ({{issue.customfield_10201}} + {{issue.customfield_10200}}))

calculation aaRaumwirkungsgrad=0.0212 * ({{aaRaumindex}}*{{aaRaumindex}}*{{aaRaumindex}}) - 0.2225 * ({{aaRaumindex}}*{{aaRaumindex}}) + 0.7844 * {{aaRaumindex}} - 0.0074

 

Somehow the last calculation is not right.

The correct formel is: 

 

Raumindex = (Breite x Länge) / ((Deckenhöhe – Höhe Nutzebene) x (Breite+Länge))

Raumwirkungsgrad = 0.0212 * Raumindex3 - 0.2225 * Raumindex2 + 0.7844 * Raumindex - 0.0074

Lichtstrom = Beleuchtungsstärke x Fläche / (Raumwirkungsgrad x 0.72)

Here a correct calculation:

Rechnungsbeispiel.png

In Jira the Raumindex and Raumwirkungsgrad calculations are correct. But for the Lichtstrom the result is 620'162.078 and that is wrong. Is the automation too complex, or why does it not work? 

2 answers

1 accepted

0 votes
Answer accepted
Muhammad Moazzam Hassan
Contributor
September 30, 2024

When you are storing a value in a variable via calculation, please use the mentioned below notations.



{{#=}} {{issue.customfield_10201}} * {{issue.customfield_10200} {{/}}

Or it will be more benfiecray if you use in every calculation.

Automation smart values - math expressions | Cloud automation Cloud | Atlassian Support

0 votes
Sam Thornton
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 30, 2024

Hey,

Have you tried adding brackets where needed, to make sure that it has the correct order of operations?

Kind Regards,
Sam

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events