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?

You can use XSLT functions to calculate Floor and Ceiling

Take a look at this >>>  

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

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):

• Floor:

  If(equals((Val01%Val02),0),round(Val01/Val02,0),(Val01-(Val01%Val02))/Val02) - If(lessThan((Val01/Val02),0),1,0)

• Ceiling:

  If(equals((Val01%Val02),0),Val01/Val02,((Val01-(Val01%Val02))/Val02)+1) - If(lessThan((Val01/Val02),0),1,0)

The subtraction part is to compensate for negative numbers.

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

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

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

Hi Jean-Pierre,

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

Regards

Leif

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

I had doubts of whether this is going to work since '%' (resp. all the arithmetic operators) is as well javascript operator.

so I tested it on my own and found out it works. a bit of surprise for me.

so I tested Math.ceil()  and to my even bigger surprise it worked as well.

not sure how and why but it really works. at least on android.

This is awesome. Great that you can use javascript functions within a calculated value in a mobile app form as well as browser.

Just not to confuse somebody, I do not say javascript works on mobile in general.

I just found single case where it worked