[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Zero Suppression



Thanks Denise.

Happy Holidays!

At 06:06 AM 12/18/2001, you wrote:
>Hi Michael,
>
>How about something like this:
>
>if trunc(#incr_msg_chrg,2) = trunc(#incr_msg_chrg,3)
>       print #incr_msg_chrg (, {COL75}) edit $$.99
>    else
>       print #incr_msg_chrg (, {COL75}) edit $$.999
>    end-if
>
>I think that should work.
>
>HTH,
>Denise White
>Sr. Programmer/Analyst
>Vicor
>------------------------------
>
>Date:    Mon, 17 Dec 2001 15:18:50 -0800
>From:    Michael Prodor <mprodor@QUALCOMM.COM>
>Subject: Zero Suppression
>
>I asked this a while back and found that there was one hole in the solution:
>
>
>Hi Gurus, here is a quick question that I've been playing with for too long.
>
>I am printing a rate field that can be up to 3 digits to the right of the
>decimal. When it is 3 digits I want to print all three, but when there are
>no significant digits, I want to display the cents and leave the rest blank.
>
>For example:
>
>If the rate is 2.340 I want to print 2.34
>
>If the rate is 2.345 I want to print 2.345.
>
>If the rate is 2.30 I want to print 2.30
>
>I have tried:
>
>     1267    print  #incr_msg_chrg (, {COL75}) edit $$.99BB
>     1268    print  #incr_chr_chrg (, {COL82}) edit $$.99BB
>
>and
>
>     1267    print  #incr_msg_chrg (, {COL75}) edit $$.BBBB
>     1268    print  #incr_chr_chrg (, {COL82}) edit $$.BBBB
>
>and
>
>1244       let $= rtrim(edit(#incr_msg_chrg,'$$.999'),'0')
>1234       print $incr_msg_chrg
>
>But neither work. Do I really have to interrogate the decimal portion to do
>this?
>
>I was going to extract the decimal portion, rtrim it and then rpad it to 2
>places, but it seems like a lot of work.
>
>Anyone think of an easier way?
>
>Thanks!
>
>
>
>--
>Michael Prodor
><mprodor@qualcomm.com>
>
>Qualcomm - IT QWBS Business Systems