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.
