Hi Richard,
Is there no way to set DQSD to preform normal arithmetic
functions?
You can use the VBSX function as a wrapper to force VB-style mathematic
operations. Here's an example:
vbsx =cdbl(2156737.51 - 16123.85)
You can add an alias for this to localaliases.txt as so:
m|vbsx =cdbl(%s)|Safe math|Safe math|Finance
Since you're calling it directly, and the formula isn't being simply
interpreted from the command-line, it is easy to raise errors by
submitting invalid values (m 1/0). So, be careful with that kind of
thing. ;)
You can use other math operators this way, too, like power (^) and
modulo (mod) and whole value division (\ - eliminates the remainder).
m 10 ^ 8
m 17 mod 4
m 9 \ 2
And more:
http://www.w3schools.com/vbscript/vbscript_ref_functions.asp#math
I'll bet with a bit of hacking in calculate.js, it would be possible to
change the default behaviour for mathematic formulae to this processing
method. Personally, I could care less. The JS method has almost always
served my needs, and when it hasn't, Google fills in nicely.
Regards,
Shawn K. Hall
http://12PointDesign.com/
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
To unsubscribe visit:
https://lists.sourceforge.net/lists/listinfo/dqsd-users
DQSD-Users@lists.sourceforge.net
http://sourceforge.net/mailarchive/forum.php?forum_id=8601
