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

How can I format a calculated total to have 1000 separators

Mike Low_jrszse

Hi,

I have 3 numeric custom fields. I have used each of the values from these fields to perform a calculation and render the value in a 4th read only text field (I'm unaware of a any numeric read only custom field so needs to be text). I have already created the necessary logic to using the following automation rule:

{{#=}}({{issue.fields.Custom Field 1}} * 100 + {{issue.fields.Custom Field 2}} * 110 + {{issue.fields.SCustom Field 3}} * 105) * 1.15 * 1.1{{/}}

I wish to format this value to have a 1000 separators as the value is currently hard to read e.g. instead of 1000000 it should render on screen as 1,000,000

I see that you can apply the format() option to a specific custom field (e.g. https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/) value but how can I apply it to a group of custom fields that are calculated into one value?

Thanks

Mike

Accepted answers

Marc Koppelaar

Hi @Mike Low

You could try the smart value asNumber.

This takes a string, and converts it to a number if possible.

All comments

Marc Koppelaar

Hi @Mike Low

You could try the smart value asNumber.

This takes a string, and converts it to a number if possible.

Mike Low_jrszse

Thanks @Marc -Devoteam- .

At what point in the rule would you place this?

In the rule I've created the Custom field 4 is not included in the calculation. It is merely selected as the field to be calculated. See below the highlighted drop down is the Custom Field 4 custom field 4.png

I tried adding a THEN component at the end of the rule = {{issue.Custom Field 4.asNumber}} but this just overrides the calculation that was made with NULL

Marc Koppelaar

Hi @Mike Low

This would require 2 extra actions in your rule I think.

Add Re-Fetch Data action
Edit action, to set the field using the smart value

Mike Low_jrszse

Thanks @Marc -Devoteam- . I tried the below (adding those 2 components after the calculation components have run but unfortunately the calculated data is still getting cleared.

I can confirm that if those 2 components are not in place the field calculates and renders successfully.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management