Rounding

Hi folk What is the best way to round the following myam=696/26 I want Myam to be 26.76 -- Kind regards Sytze de Boer Kiss Software --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

Re: Rounding

On 10 January 2014 19:55, Sytze de Boer sytze.k...@gmail.com wrote: Hi folk What is the best way to round the following myam=696/26 I want Myam to be 26.76 Hi Sytze, how about: FLOOR(696/26*100)/100 You might want to try a few other values! -- Paul

Re: Rounding

Hi Thanks Paul I also found myam=VAL(TRANSFORM(696/26,#.##)) On Sat, Jan 11, 2014 at 9:02 AM, Paul Hill paulroberth...@gmail.com wrote: On 10 January 2014 19:55, Sytze de Boer sytze.k...@gmail.com wrote: Hi folk What is the best way to round the following myam=696/26 I want

Re: Rounding

+1 for Transform! After I discovered the power of the Transform(), my Foxlife was never the same. :) Mike Copeland Original Message Subject: Re: Rounding From: Sytze de Boer sytze.k...@gmail.com To: profoxt...@leafe.com Date: 1/10/2014 3:25 PM Hi Thanks Paul I also found

RE: Rounding

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

RE: Rounding DOWN

-Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de Boer Sent: Wednesday, January 25, 2012 3:00 PM To: profoxt...@leafe.com Subject: Rounding DOWN Hi Folk What is the best way systems round Down ? e.g. 1.9256 to 1.92 5.565

Re: Rounding DOWN

Sent: Thursday, January 26, 2012 2:29 AM To: profoxt...@leafe.com Subject: Rounding DOWN Hi Folk What is the best way systems round Down ? e.g. 1.9256 to 1.92 5.565 to 5.56 4.449 to 4.44 -- Regards Sytze de Boer --- StripMime Report -- processed MIME parts --- multipart/alternative

RE: Rounding DOWN

Sytze de Boer wrote on 2012-01-25: Hi Folk What is the best way systems round Down ? e.g. 1.9256 to 1.92 5.565 to 5.56 4.449 to 4.44 Sytze, The FLOOR() function. Or just INT() if your numbers are always greater than 0. Tracy Pearson PowerChurch Software

Re: Rounding DOWN

That's not really rounding down, that's truncating.    From: Tracy Pearson tr...@powerchurch.com To: profox@leafe.com Sent: Wednesday, January 25, 2012 4:01 PM Subject: RE: Rounding DOWN Sytze de Boer wrote on 2012-01-25:   Hi Folk     What is the best way

Re: Rounding DOWN

What is the best way systems round Down ? ROUND(nValue-0.5, 0) INT() and FLOOR() both have issues with numbers very close to the boundary due to the lack of precision with floating point numbers. When you say rounding down you might need to check how to handle negative values. Some customers

Re: Rounding DOWN

, Christof Wollenhaupt wrote: What is the best way systems round Down ? ROUND(nValue-0.5, 0) INT() and FLOOR() both have issues with numbers very close to the boundary due to the lack of precision with floating point numbers. When you say rounding down you might need to check how to handle

Re: Rounding DOWN

Hi Andrew, I think Chrisof meant ? ROUND(1.920001-0.005,2) ? ROUND(1.92-0.005,2) Yep, thanks! Christof --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post

VFP Rounding

Hi all, Hoping you can shed some light for me. I've got a calculation that I'm doing over 4 fields and then I convert the result to character by applying STR() function - doing this to a length of 20 and decimal places of 2. This rounds UP my result. I don't want this to happen. Just want

Re: VFP Rounding

You could always multiply by 100, apply the integer function, then divide by 100. Richard E. Quilhot C.N.A. quilh...@gmail.com On Tue, May 4, 2010 at 6:00 PM, Tina Currie t...@datahouse.com.au wrote: Hi all, Hoping you can shed some light for me. I've got a calculation that I'm

Re: VFP Rounding

You can try this. SET DECIMALS TO 1 more than you're formatting, in your case 3. Then use TRANSFORM(your number,9.99) to get it as a string. As long as the SET DECIMAL is at least 1 more than you're formatting to, it will truncate, not round. Fred On Tue, May 4, 2010 at 3:00

RE: VFP Rounding

-Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tina Currie Sent: Tuesday, May 04, 2010 3:00 PM To: profoxt...@leafe.com Subject: VFP Rounding Hi all, Hoping you can shed some light for me. I've got a calculation

RE: VFP Rounding

precision. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, May 04, 2010 6:15 PM To: profoxt...@leafe.com Subject: RE: VFP Rounding Use TRANSFORM with a picture clause if you're not interested in the extra

RE: VFP Rounding

-Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tina Currie Sent: Tuesday, May 04, 2010 6:00 PM To: profoxt...@leafe.com Subject: VFP Rounding Hi all, Hoping you can shed some light for me. I've got a calculation that I'm doing over

Re: VFP Rounding

What about floor() - Original Message - From: Richard Kaye rk...@artfact.com To: profox@leafe.com Sent: Tuesday, May 04, 2010 3:32 PM Subject: RE: VFP Rounding And as someone else mentioned you do need to set decimals to some number greater than the precision you want to preserve

RE: VFP Rounding

Thanks Richard, That did the trick :-) Glad I just asked rather than screwing around with that for too long! Tina -Original Message- From: Richard Quilhot [mailto:quilh...@gmail.com] Sent: Wednesday, 5 May 2010 8:14 AM To: ProFox Email List Subject: Re: VFP Rounding You could always