Return to FileMaker.com
round up to 250 increment
Hi guys, i'm creating a PM schedule maintenance database and I need to round machine hours by 250 hour increments eg, 17,224 rounds up to 17250, 26610 rounds up to 26750 and 29,754 rounds up to 30,000. How would I represent that into a formula?
Try: Ceiling ( rounds field / 250 ) * 250
Retrieving data ...