cancel
Showing results for
Did you mean:
Nintex Newbie

## Nintex Forms - math function

Hi,

I have a case where I need to divide two numbers and round up to nearest integer and store the result in a calculated field. This is commonly known as a "ceiling" function.

ExampleDivisionRoundFloorCeiling
100 / 1010101010
18 / 101.8212
12 / 101.2112
3 / 100.3001

I can only seem to find a "round" function. Neither the "Floor" og the "Ceiling" is available as far as I can see.

Any ideas on how to overcome this?

Regards

Leif

Labels: (1)
• ### Workflow

12 Replies
Highlighted Automation Master

## Re: Nintex Forms - math function

Hi

I have done the following before:

Take the value you have from division above and do the following:

1. calculate round

2. if round = division ---> set ceiling and floor = division

3. if round > division ---> set ceiling = round, floor = round - 1

4. if round < division ---> set ceiling = round + 1, floor = round does that make sense? Highlighted
Nintex Newbie

## Re: Nintex Forms - math function

You can use XSLT functions to calculate Floor and Ceiling

Take a look at this >>>

Highlighted Automation Master

## Re: Nintex Forms - math function

from calculated value control you can directly call javscript function, so something like this might help  Highlighted
Nintex Newbie

## Re: Nintex Forms - math function

Also, there's the % operator which gives you the remainder of a division. So 18%10 will return 8. Using the If() you could come up with the calculated value formulas that you're looking for.

For example the below seems to do the trick for me (using result examples from Wikipedia):

The subtraction part is to compensate for negative numbers.

Highlighted
Nintex Newbie

## Re: Nintex Forms - math function

Hi Cassy,

It definately makes sense - thanks for your input. I will have to wrap it in some nested "if/then" structure inside my formula however, since my problem relates to Forms instead of Workflow.

Regards

Leif

Highlighted
Nintex Newbie

## Re: Nintex Forms - math function

Hi Fernando,

I am not sure if this can somehow be utilized in a form. Is it not only within a workflow that this is working?

Regards

Leif

Highlighted
Nintex Newbie

## Re: Nintex Forms - math function

Hi Marian,

I hadn't thought of this. This is definately worth trying as long as Mobile Forms are not required - which it fortunately isn't in my case Regards

Leif

Highlighted
Nintex Newbie

## Re: Nintex Forms - math function

Hi Jean-Pierre,

That's pretty awesome - simple but efficient. And it will work in Mobile Forms as well Regards

Leif

Highlighted Automation Master