Rounding Calculation

[lbrocka]

I'm having a problem with rounding to nearest quarter (.25) I have a number times a billing factor which then needs to round to nearest .25. Hope someone has an answer 'cause this is making me nuts. Thanks

[Vaughan]

Use a calculation field and the Round() function.

[LeCates]

Hi Lori,

To round to the nearest .25:

code:

---

calc = Round(num*4, 0) / 4

---

To generalize for rounding to any fraction:

code:

---

calc = Round(num*(1/fraction), 0) / (1/fraction)

---

Good luck!

[ November 04, 2001: Message edited by: droid ]

[lbrocka]

Thank you! It was the fraction that was causing me to pull my hair out.