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
