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

Math expressions resulting in two digits

ray_1m1uxv

Is it possible with math expressions to have a result of always 2 digits?

f.e.
{{#=}}1+2{{/}} = 03 instead of just 3
{{#=}}1+10{{/}} = 11

I was trying to do a check with IF(condition,value_if_true,value_if_false) to place a "0" in front of the result when it's <10 but that didn't work out...

Accepted answers

All comments

Bill Sheboy

Hi @ray

Are you asking about text fields (or output) or number fields? I text fields, that is possible, but it is not possible to store a number field as the leading digits would drop when saved.

Let's assume your output is either a text field or output to the log, email, or a text field...

I believe if you use the inline math operations instead, you could add the format() function on the end to get that result.

{{someField.plus(someNumber).format("000")}} -- this would prefix 3 digits with leading zeros

However if you are using numbers without any field references, you would do this in three steps:

perform your math operation and save the value in a text field
re-fetch the issue to reload the saved value
update the field, using the leftPad() function to set your number of leading digits

Kind regards,
Bill

ray_1m1uxv

Hi Bill;

The outcome of the math should be in the summary-field, so a text field. I can f.e. fetch the week number by adding xxxxxxx.format("ww"). But whenever i'm calculating someting like f.e. {{#=}}1+2{{/}}, then the result is always 3 and not 03

Bill Sheboy

Ray, please try to stick to one thread when responding. That will help others in the future know if there are multiple answers to a question. Thanks!

Would you please explain what problem you are trying to solve?

I suggested a method to format numbers stored in fields/smart values as text with left-padding. However if you have a known, literal expression like {{#=}}1+2{{/} why wouldn't you just replace that with "03" instead of doing the math?

ray_1m1uxv

To respond to your question: because the summary is based on several calculations to number the task based on week numbers. But not only weeknumber, because weeknumber only could be formatted with xxxxx.format("ww"). But whenever I try to f.e. add +1 to the resulted weeknumber, the formatting will not by 2 digits, but only when when it's below 10.

This is my calculation:
{{triggerIssue.customfield_13403.format("ww")}}-FLOOR({{triggerIssue.customfield_13403.format("ww")}}/2){{/}}

the result should be f.e. 03 instead of 3 when it's below 10. I could hard code a "0" as prefix, but that's a manual solution

Bill Sheboy

That is different than what you described, as you are in fact using issue fields. Because of that you can write that as a single expression, using the inline, math operations.

{{triggerIssue.customfield_13403.format("ww").minus(triggerIssue.customfield_13403.format("ww").divide(2).floor).format("00")}}

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-core