Technically that's not "rounding"; It's truncating the value to the 2nd decimal place. Rounding to 2 digits of precision for that result should be 26.77. So if you want rounding to two places, you should use ROUND(696/26,2). Otherwise either the FLOOR or the TRANSFORM will do the trick. And knowing the Fox there's probably other ways...
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: Friday, January 10, 2014 4:26 PM To: [email protected] Subject: Re: Rounding Hi Thanks Paul I also found myam=VAL(TRANSFORM(696/26,"#####.##")) _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD044229CE9EAAC@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
