cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
leif_frederikse
Nintex Newbie

Nintex Forms - math function

Jump to solution

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)
Reply
12 Replies
Automation Master
Automation Master

Re: Nintex Forms - math function

Jump to solution

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?

Reply
fhunth
Nintex Newbie

Re: Nintex Forms - math function

Jump to solution

You can use XSLT functions to calculate Floor and Ceiling

Take a look at this >>>  

Reply
Automation Master
Automation Master

Re: Nintex Forms - math function

Jump to solution

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

Reply
jpmhuls
Nintex Newbie

Re: Nintex Forms - math function

Jump to solution

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.

Reply
leif_frederikse
Nintex Newbie

Re: Nintex Forms - math function

Jump to solution

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

0 Kudos
Reply
leif_frederikse
Nintex Newbie

Re: Nintex Forms - math function

Jump to solution

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

0 Kudos
Reply
leif_frederikse
Nintex Newbie

Re: Nintex Forms - math function

Jump to solution

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

Reply
leif_frederikse
Nintex Newbie

Re: Nintex Forms - math function

Jump to solution

Hi Jean-Pierre,

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

Regards

Leif

0 Kudos
Reply
Automation Master
Automation Master

Re: Nintex Forms - math function

Jump to solution

Yeah sorry about that I went off on one without reading the title of the question properly! Glad you got a resolution! 

Reply