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

Eazybi help needed with converting text number with % in to number to create calc field

Ed Richard

Have a custom jira field called PercentDone where the entries are text based and end in a "%" sign such as 95%. Trying to create a calculated field in Eazybi reporting add on that will multiply a number by that percentage. Have spent countless hours with Val and ExtractString and all the possible arguments but just get errors returned.

Just trying to turn the 95% into a number (without multiplying it by anything does not work... so even solving that would be big)

Val(ExtractString([Issue].CurrentHierarchyMember.get('Percent Done'),'.%(\D+)',1))

There is unfortunately no more than one example in the doc or from a google search on ExtractString. I know there are other workarounds and things I could do back in Jira so Im only dealing with a number off the bat but I want to solve the type conversion issue for future things. Also know there may be something big I'm missing and that there is an answer but I have to cap the number of hours being wasted on permutations.

Accepted answers

Daina Tupule eazyBI

You are quite close using ExtractString.

\D will represent non-digit, you would like to use \d there instead. You are using dot (.) before the percentage sign as well. It will look for some character before the dot. You would like to use a percentage sign (%) after the number as well.

I would suggest this formula to transform 95% to 95:

Val(ExtractString([Issue].CurrentHierarchyMember.get('Percent Done'),'(\d+)%',1))

Another approach would be using a function Replace, where you can replace % in any position in the field leaving the numeric value only. Please make you have a numeric value only after this transformation. If you have some spaces consider using an additional Trim function. This will work for, 95 %, % 95, 95%

Val(Trim(Replace([Issue].CurrentHierarchyMember.get('Percent Done'),'%',"")))

Daina / support@eazybi.com

All comments

Daina Tupule eazyBI

Val(ExtractString([Issue].CurrentHierarchyMember.get('Percent Done'),'(\d+)%',1))

Val(Trim(Replace([Issue].CurrentHierarchyMember.get('Percent Done'),'%',"")))

Daina / support@eazybi.com

Ed Richard

thanks so much.. I have my number!.. quick follow-ups.. now that I can ignore the "%" sign its being treated as a whole integer so is there a way to multiply by .95 (point 95) and not the integer 95?.. also.. is there a way to concatenate in my own text character similar to the way you do in excel for example where you specify =A2&" my custom text "& A1 in the final result?.... (hope im not pushing to hard after getting what i originally asked for)... really appreciate it Daina

Ed Richard

Oh wait.. for the first part, I can add a / 100.... still interested in the second concat part though

Daina Tupule eazyBI

Hello Ed,

Yes, division by 100 is the best way on how to get the value .95 and use it as a percentage in eazyBI.

You can use double straight lines || to concatenate strings. You can check this example report in our demo account where we combine different information concatenating strings with numbers and dates. Numbers and dates should be transferred to strings for this.

Daina / support@eazybi.com

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server