Format number in jmcf

[Antonio Caeiro]

Hi,

i need to format the following number 200,000% to 200% in JMCF.

Any advise?

I'm using this code in Number Format Expression form Groovy script that returns a string representing the value of the calculated number custom field.

value
numberTool.format('percent',value)

tks

[David Fischer · Accepted solution]

Hi @Antonio Caeiro ,

it looks like the calculated value is 2000, not 2. A value of 2000 would be displayed as 200,000% (with the thousands-separator comma). You can check this by removing the number format expression. In that case, you have 2 options:

- update the "Formula" to return 2 instead of 2000 (divide the value by 1000)

- update the number format expression to divide the number by 1000: 

numberTool.format('percent',value/1000)