|
Mike: <snip> Hey, I want to round to the whole dollar. But I am not doing any calculation on the field, so the EVAL(H) won't work for me. Or will it? This is the line I need to modify: "output = %trim(output) + ',' + %char( NIBT.balance)". Any good ideas short of writing a subprocedure? The NIBT.balance is the dollar amount. This dumps to a CSV file. </snip> How about replacing %char(NIBT.balance) with %char(%dech(NIBT.balance : precision : 0) where "precision" is the number of positions to the left of the decimal point? Since you're also trimming leading zeros via %char, you can make precision as large as you like to accommodate future requirements for a larger balance amount. --Bruce Guetzkow
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.