I'm you have DECIMALS set to 2 but I can't recall what you wrote in the original post. :-)
My rough guess would be that the last digit is showing up because the TRANSFORM picture clause includes 3 places and it gets applied after DECIMALS does its magic. If you change your TRANSFORM to 4 nines of precision (i.e. transform(0.042,"9.9999")), do you get "0.0400"? -- rk -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Thursday, February 26, 2015 1:07 PM To: profoxt...@leafe.com Subject: Re: Truncated Decimal Digits At 05:01 2015-02-26, Ted Roche <tedro...@gmail.com> wrote: >If only there was some reference other than the help you could go to >for these kinds of things... I already did that. >Tamar wrote: "These two commands determine display and calculation of >numbers involving decimals. SET DECIMALS determines the minimum number >of decimals used and displayed. SET FIXED determines whether the SET >DECIMALS value is also the maximum number displayed." > >There's quite a bit more, in the SET DECIMALS topic in HackFox. Yes, I know. I checked it before posting. None of it seems relevant, and it might even be incorrect. I have 0.042 and want "0.042" but get "0.040" with transform(0.042,"9.999"). "SET DECIMALS determines the minimum number of decimals used and displayed."? So why is it seemingly the *maximum* in my case? I am getting only two decimal digits instead of the three that the number has. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/cy1pr10mb0218db630932b5fbac1c030ad2...@cy1pr10mb0218.namprd10.prod.outlook.com ** 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.