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
|