[sqr-users] Rounding and formatting

["Poonam Auluck" <poonam.auluck@ams.com>]

Hi All -

Anyone familiar w/ rounding??  I got the rounding function to work, but
then I'm having problems formatting my number.  I'm doing three steps.


begin-select
sum(data) &data                          !pick up the data from db

          let #data = &data              !setting it to a numeric variable
          let #data = round(#data,0)          !rounding to the nearest
whole number
               !At this point, I would also like for the value to include
commas to represent 1000's, etc.  But it does not.
          let $data = to_char (data)          !Here I convert the number
into a string, but I need to set it to another procedure to do
          do H_AlignRight..($data, etc)            !some right alighnment
...it already calculates what to do...)
          print $data (#row,#column)


from bf_data
where...etc...
end-select

I tried edit masks, instead of rounding, but then I was unable to alighn it
correctly.
I tried ... let #data = round(#data,0) edit '999,999,999,999'..but that
didn't work.
I tried let #data = #data edit '999,999,999,999'...but that didn't work
either.

     I keep getting these type of errors:
        (SQR 4009) Function 'edit' missing parentheses.
      let #data = #data EDIT 999,999,999,999

OR
     Error on line 599:
      (SQR 4009) Function 'edit' missing parentheses.
      let #data = (round(#data,0)) EDIT 999,999,999,999

Any ideas how to accomplish this???

Thanks in advance.
Poonam

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users