Mark Smith wrote:
See the entry for 'statRound' in the docs...
Yeah - but I wish there was a way to get this form of rounding in the
format command.
Hmmmm -an enhancement !! I'll request it .... BZ 3111 added
-- Alex.
On 7 Sep 2005, at 19:44, Alex Tweedly wrote:
Dom wrote:
another example: to make the sum of a field, and to yield a formatted
result:
on closefield
put the short name of the target into tfield replace comma with
"." in fld tfield -- european currency delimiter ;-)
put fld tfield into montants
replace return with comma in montants
put "S" & tfield into ttotal
put format("%3.2f",sum(montants)) into fld ttotal
end closefield
"european currency delimiter" reminds me .... you need to be cautious
about using format for currency values.
Many countries (e.g. UK) have rules about how rounding should be
performed on currency values in some circumstances; this is typically
NOT the same method as used by Rev.
Rev will round as needed to the specified number of places after
decimal point (i.e. 2 in the code above). The rounding used is such
that midway values (i.e. exactly '5' in the following position) will
round upwards (e.g. 0.125 --> 0.13, 0.135 -> 0.14, etc.)
The UK rules on currency conversion required that for such "midway"
values you should always round to the even valued adjacent value
(e.g. 0.125 -> 0.12, 0.135 -> 0.14) - which had the advantage of
balancing out the rounding amounts over a large enough set of values.
--
Alex Tweedly http://www.tweedly.net
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/90 - Release Date:
05/09/2005
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
--
Alex Tweedly http://www.tweedly.net
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/90 - Release Date: 05/09/2005
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
