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?

[Abimbola Oye · Accepted solution]

my setup

[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.

• https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/#Ceil
• https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/#Functions

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