Yea I did that and it worked thanks. Wondering why the formatting was so different for a character between the fat and thin clients. Brian
________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Wednesday, July 01, 2009 2:29 PM To: [email protected] Subject: Re: Set Fields Column Sum - formatting problem ** I believe if you set it to a decimal field this would cut off the extra characters. I could be wrong... Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sokol, Brian Sent: Wednesday, July 01, 2009 2:04 PM To: [email protected] Subject: Set Fields Column Sum - formatting problem ** If I use a set fields and do a column sum in the fat client the field looks like this: 664,772.86 On the web it looks like this: 664772.860000 Anyone know why this field is formatted like this on the MidTier? Can I force it to be formatted correctly? I am on version 7.1 for both ARS and Mid Tier. The field displaying the value is a character field displayed as text. Thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com <http://www.scholastic.com/> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
