Rounding To The Half HalfRound.FP7
Under the hood, there is no way to round a number to the half. However, using a calculation with a CASE and the INTEGER number function, you can.
(Number Example - Int(Number Example)) ≥ .75, Int(Number Example) + 1,
(Number Example - Int(Number Example)) ≥ .25, Int(Number Example) + .5,
So what we are doing it taking an entered number and subtracting it’s INTEGER result. This leaves us with a fraction residue. We look at this residue, depending on it’s value, we add, subtract or do nothing to the integer result.
An example file can be downloaded at ...
More info about the author and FileMaker in general, contact me at email@example.com.
© 2008 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.
====================== ADVERTISEMENT ==============================
For more information on the InBizness SOHO and other quality FileMaker framework solutions, please visit http://www.dwaynewright.com/solutions.html