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:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Wednesday, July 01, 2009 2:04 PM To: arslist@ARSLIST.ORG 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: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"