All:
RBG11 Current
For charting wide ranges of values, I perform incremental rounding to
simplify display and interpretation (e.g. who cares about $13,437.17
when $13,500 will do? ).
This is the first time I've attempted to dynamically round with a
full-set of preset increments, using this IFF construct (expanded for
clarity ):
{Assign value-range incremental rounding values. }
SET VAR v102_roundingValue = +
(IFF('.v102_roundingTarget = 0.00 ', 0.00,
+
(IFF('.v102_roundingTarget BETWEEN 0.01 AND 4.99 ', 0.25,
+
(IFF('.v102_roundingTarget BETWEEN 5.00 AND 1000.00 ', 5.00,
+
(IFF('.v102_roundingTarget BETWEEN 1001.00 AND 10000.00 ', 10.00,
+
(IFF('.v102_roundingTarget BETWEEN 10001.00 AND 100000.00 ', 25.00,
50.00 +
)) )) )) )) ))
This works ... sort of. When the routine runs outside of TRACE mode, all
increments except 50.00 are ignored. All v102_roundingTarget values are
rounded by 50.00.
And the kicker is, when I step through the code with F10 in TRACE mode,
the proper increments are applied.
Does anything look out of place here?
Thanks much! Bruce
Bruce A. Chitiea | SafeSectors, Inc.
1142 S Diamond Bar Blvd #442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/em0a19783d-ef4d-4a17-9087-5bf33046be8d%40safesectors.com.
