0

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

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    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

    • Central Park Furnishings
    • Michael_McKenna
    • 3 yrs ago
    • Reported - view

    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. 

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Thank you Michael, and a Happy New Year to you too.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 415Views