Thanks... The Real Number field fixed it. I assumed that a character field would work since it could hold any text/numbers, but I was obviously wrong.
Thanks again. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation Hi, The problem is that the contents go to a text field, so if you want to do maths, you need to go via a numeric field: Set-Fields 1: tmpreal = $Field1$ / 100.0 Set-Fiedls 2: Testfield = $tmpreal$ Or maybe you can do something like this: Set-Fields: Testfield = ROUND($Field1$ / 100.0) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > I have it like your first example. > > I was just reusing an existing test field I had thinking a character field > would be ok, but I will try a Real Number field to see if that is causing > a problem. > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS > Sent: Monday, November 14, 2011 9:50 AM > To: arslist@ARSLIST.ORG > Subject: Re: Set Field Calculation > > ** > When you do the set field do you have it as: > $Field1$ / 100 > > OR > $Field1$ + " / 100" > > The 2nd one the system will definitely see as concatenation not a > mathematical function. > > Also, why can't Testfield be a real number also? > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. > Sent: Monday, November 14, 2011 7:47 AM > To: arslist@ARSLIST.ORG > Subject: Set Field Calculation > > ** > I am attempting to use an escalation to perform a set field action using > mathematical calculation. > >>From reading the documentation it seems that I should be able to do this, >> but I can't seem to get it work. > > I want to do something like: > > Name: Testfield > Value: Field1 / 100 > > Field1 is a Real Number field, > Testfield is Character field. > > Andy L. Mayfield > Alabama Power Company > Protection & Control Technician Sr. > Linc # 10*19140 > Cell # 205-288-9140 > Office # 205-226-1805 > > _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the > Answers Are"_ > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
