Create a Calculated Text Field Converting Text Values to Numbers

Anthony Cardone_sunqoi

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") !=<span>&nbsp;</span>null ? issue.get("customfield_10114") :<span>&nbsp;</span>0) + (issue.get("customfield_10150") !=<span>&nbsp;</span>null ? issue.get("customfield_10150") :<span>&nbsp;</span>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!

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