Paradox Community

Items in pnews.paradox-development

Subject:Re: formatting
Date:Fri, 6 Apr 2018 19:00:10 +0100
From:Michael Kennedy <Info@KennedySoftware.ie>
Newsgroups:pnews.paradox-development
??!?@@$??  here too   ;-)

If you change the w.2 to w.10, does it have any effect?

Is the field defined as N or $:
   - If $, maybe the rounding is being applied BEFORE the calc.
   - If N, I've no idea what's triggering the rounding.

Mike


On 06/04/2018 17:13, Steven Green wrote:
> I have a field called Useage.. no formatting or rules on the actual 
> field, just a raw Number field that often has up to 4 decimal places
> 
> on a form, I display it "w.2", but I can click on the field and see the 
> actual value, if it's .025 or anything like that.. so far, normal 
> behavior that I expected
> 
> but when I use that field in a calc, it's using the formatted version of 
> the field, not the real field.. in the example above, it showed me .03 
> on the form, of course.. I clicked on it and saw .025.. it did the 
> resultant math with .03.. but I look at the table afterwards, it's .025
> 
> useage * tc.unitcost
> 
> in my example, tc.unitcost is 182.. times .025 is 4.55, times .03 is 
> 5.46.. it's displaying 5.46
> 
> 
> ??!?@@$??
> 
> 
> -- 
> 
> Steven Green
> Myrtle Beach, South Carolina, USA
> 
> http://www.OasisTradingPost.com
> 
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too


Copyright © 2004 thedbcommunity.com