Formula to Round up to .5 or full number.
Looking for help with a formula to round up to half numbers. Example: if my value is “3.245”, I would like to round upto 3.5 or if its greater than the half , “3.650” then round up to full number, 4. My value will be always different. I have tried the ceil(Field) and the round(field,2) . Hope someone can help. Thank you
3 replies
-
let n := Number % 1;
if n = 0 then
Number
else
if n < 0.5 then
Number - n + 0.5
else
if n > 0.5 then Number - n + 1 else Number end
end
end -
Steven yet again you are a winner. I would never of come up with that in a million years, you are truly appreciated because without you answering these questions l would not be able to proceed with making my data base. Happy New Year
By the the way, it worked a treat. -
Thank you Michael, and a Happy New Year to you too.
Content aside
- 4 yrs agoLast active
- 3Replies
- 428Views