0

Round Up

I need a function to round UP to the nearest 100.  The manual references both "round up" and "ceil" functions but both return the error "function is not defined".  The formula "round('FIELD' / 100, 0) * 100 work except it rounds to the NEAREST 100, not UP.  Any help?

2 replies

null
    • Birger_H
    • 5 yrs ago
    • Reported - view

    try it like this:

    –––
    ceil('FIELD' / 100) * 100
    –––

    Birger

    • Jeff_Fackler
    • 5 yrs ago
    • Reported - view

    That worked!  Thanks

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1358Views