Subject: | Re: formatting
| Date: | Fri, 6 Apr 2018 13:01:56 -0500
| From: | Mark Bannister <markRemove@THISinjection-moldings.com>
| Newsgroups: | pnews.paradox-development
|
That sounds vaguely familiar..... could actually be useful if it you
knew about it and it was consistent.
Have you tried the difference of:
usaage * tc.unitcost
vs
usaage.value * tc.unitcost
?
--
Mark B
On 4/6/2018 11:13 AM, 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
|