Set Equation

Hello @relisys,

The process is really simple, you are dividing the number by 20.

For example, assuming the number field in the form is fieldname1, the equation would be:

fieldname1/20

If you need only the whole part of division:

FLOOR(fieldname1/20)

If you want round the result to the nearest integer number:

ROUND(fieldname1/20)

Best regards.

this is the one I got, (fieldname2 fieldname1/20) thank you for confirming, is there any way of setting the results of 1, 1.5, 2, 2.5 so on and so forth.

Hello,

The equation (fieldname2 fieldname1/20) is incorrect, it should be simply fieldname1/20

Now, if you want to round the results as 0, 0.5, 1, 1.5, 2, 2.5, … It is simple mathematics

ROUND(fieldname1/20/0.5)*0.5

and that’s all.
Best regards.

oh, no they enter a value in fieldname2 and the output is in fieldname1/20) I get the correct results, however, I do it.

and next mathematics you provide is fantastic, this is what I wanted. thank you again.

Hello @relisys,

It has been a pleasure to help you.

If you need additional help to implement your project, I can offer you a custom coding service from my private website:

https://cff.dwbooster.com/customization

Best regards.

ok thank you, I will keep you in mind if I come across needing this service.