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 to use CEIL expression to round to the nearest 100

Abimbola Oye

I created a customfield - WirelessRound and use the expression below to calculate the value:

{{#=}} ({{issue.customfield_13329}} / 100)* 100 {{/}}

the expression gave the correct value of 1925.

2nd Step:

I want to round the 1925 to 2000 using the expression below

{{#=}} {{issue.customfield_15030}}.ceil {{/}}

I got the error message:

Unable to render smart values when executing this rule:

Unknown unary operator . at character position 1: .ceil

What am I doing wrong here?

Accepted answers

Abimbola Oye

my setup Screenshot 2025-04-22 100922.png

All comments

Abimbola Oye

my setup Screenshot 2025-04-22 100922.png

Bola Oye

Can someone help me navigate the problem. I still have the error message:

I got the error message:

Unable to render smart values when executing this rule:

Unknown unary operator . at character position 1: .ceil

Bill Sheboy

Hi @Abimbola Oye -- Welcome to the Atlassian Community!

There are two versions of the ceiling function: one inline (which may not help for your case) and the longer form one, ceiling(). You are trying to mix the syntaxes, which will not work.

The inline version may not work for your case because if the value is an integer, your division will become integer division, and you have the function outside of the smart value expression.

To get the nearest 100 using the ROUND() function, you may do this in one step with this expression:

{{#=}} ROUND( {{issue.customfield_13329}} / 100, 0 ) * 100 {{/}}

Kind regards,
Bill

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