Create a Calculated Text Field Converting Text Values to Numbers

[Anthony Cardone]

Hello,

I'm trying to create a Calculated Text field where I take 2 different custom fields, assign those text values a numeric value, and add them together. 

If both custom fields were numbers, I believe this code would work.

<!-- @@Formula: (issue.get("customfield_10114") != null ? issue.get("customfield_10114") : 0) + (issue.get("customfield_10150") != null ? issue.get("customfield_10150") : 0) -->

As an example:

Let's say I create 2 custom fields that are Select Lists (Single Choice) called Priority and Severity.
Each one contains the following values: High, Medium, Low, Not Applicable.
I want to assign a value of 5 to High, 3 to Medium, 1 to Low, and 0 to Not Applicable, and add those Priority and Severity totals together into a calculated field to return a value.

Can someone point me in the right direction? Thank you!

[DevOps-Tally.]

hi, im not able to view this page "https://bitbucket.org/fcarmario/jira-workflow-toolbox/wiki/amazing/Set%20a%20Field%20as%20a%20Function%20of%20other%20Fields"

Can someone help please

[Max Foerster - K15t]

Good morning @DevOps-Tally. ,

the documentation was completely upgraded and moved some time ago. You can find it here now:

• for JWT 3.x and newer: https://apps.decadis.net/display/JWTSDC
• for JWT 2.x and earlier: https://apps.decadis.net/display/JWT
• for JWT for Jira Cloud: https://apps.decadis.net/display/JWTCLOUD

The function you are looking for has been renamed to Update field based on rules.

Best, Max

[arige hamdan]

Hi,

I found another shorter solution than suggested in your shared link above:

you can use this:

toNumber(%{id-customfield1})*toNumber(%{id-customfield2})

[DevOps-Tally.]

Hey,Im very very new to coding and would need help in writing this from scratch.Even if you can help with a sample that i can edit that would be of great help. I have the same requirement and struggling to have a fix. 

[Anthony Cardone]

I'm responding to myself from my work account... I did find a way to do this using the Jira Workflow Tools plugin... This link outlines how to do it using their post functions and assigning numeric values to the words in the list options, and storing it in Ephemeral numbers, to then add it all up in a numeric custom field. 

https://bitbucket.org/fcarmario/jira-workflow-toolbox/wiki/amazing/Set%20a%20Field%20as%20a%20Function%20of%20other%20Fields

[arige hamdan]

thanks a lot for sharing the solution.